Issue 61869 - HSQL access/field update via attached macro doesn´t work
Summary: HSQL access/field update via attached macro doesn´t work
Status: CONFIRMED
Alias: None
Product: Base
Classification: Application
Component: code (show other issues)
Version: OOo 2.0
Hardware: All All
: P3 Trivial with 1 vote (vote)
Target Milestone: ---
Assignee: AOO issues mailing list
QA Contact:
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2006-02-09 20:45 UTC by sarotti
Modified: 2017-05-20 10:47 UTC (History)
1 user (show)

See Also:
Issue Type: DEFECT
Latest Confirmation in: ---
Developer Difficulty: ---


Attachments

Note You need to log in before you can comment on or make changes to this issue.
Description sarotti 2006-02-09 20:45:22 UTC
Using a makro to access and update HSQL databases produces an error. Here is the 
macro code:

Sub ResetTMP
 
Dim DatabaseContext as Object
Dim s as string
Dim oDatenquelle as Object
Dim oHandler as Object
Dim oDatVerb as Object
Dim oStatement as Object
Dim oErgSet as Object
Dim sSQL as String
 
 
DatabaseContext = createUnoService("com.sun.star.sdb.DatabaseContext")
oDatenquelle = DatabaseContext.getByName("Adress_db")
 
If not oDatenquelle.IsPasswordRequired Then
oDatVerb = oDatenquelle.getConnection("","")
else
oHandler = oDatenquelle.createUnoService("com.sun.star.sdb.InteractionHandler")
oDatVerb = oDatenquelle.ConnectWithCompletion(oHandler)
end if
 
oStatement = oDatVerb.createStatement()
oStatement.ResultSetConcurrency =
com.sun.star.sdbc.ResultSetConcurrency.UPDATABLE
oStatement.ResultSetType = com.sun.star.sdbc.ResultSetType.SCROLL_SENSITIVE

sSQL ="SELECT ""TMP1"", ""TMP2"", ""TMP3"" FROM ""TMP"""
 
oErgSet = oStatement.executeQuery(sSQL)
 
oErgSet.absolute(1)
 
REM die folgenden 3 Zeilen ändern den Inhalt der 1.-3.
Spalte des Ergebnisses der Abfrage "sSQL"
 
oErgSet.updateString(1, "text1") 'here you get the error
oErgSet.updateString(2, "text2")
oErgSet.updateString(3, "text3")
oErgSet.updateRow()

End sub
 
The error:
 
Basic runtime error
...exception....
Type: com.sun.star.sdbc.SQLException
Message: Function Sequence error.

Using other databases (like access)the update function with the macro will run.

best regards

- Jörg Leistikow -
Comment 1 marc.neumann 2006-02-10 08:51:41 UTC
Hi,

I can reproduce this, reassign it to the right developer and set target.

Bye Marc
Comment 2 Marcus 2017-05-20 10:47:30 UTC
Reset assigne to the default "issues@openoffice.apache.org".