Base.HSQL: Reference, Call Identity

Wolfgang Schaible <[email protected]>
Newsgroups gmane.comp.openoffice.dba.user
Organization atHome
Message-ID <[email protected]>
hi,
   Have a DB 1:n, n:0|1, 0|1:1 and some ro-tables feeding listboxes, 
all together driven by BASIC and DIALOG (was not able to create a 
understandable, simple GUI using FORMs and REPORTs).

During inserting a new record 'n' one must supply the reference to 
the higher record '1'. My clumsy method is:
'getREF SID (the higher level):
   s_SQL(16)="SELECT SID FROM "+sJS+  " ORDER BY SID DESC"
   oReSe      =oStmt.executeQuery(s_SQL(16))
   oReSe.next()
   SID          =oReSe.getInt(1)

The (H)SQL-Syntax knows the function 'CALL IDENTITY()'
but
how can I use it?

oStmt.executeUpdate(...)  goes on strike...

Any solution?

Kind regards
Wolfgang
lmpx.com only provides a reader for public news (NNTP) servers. It is not affiliated with the servers or forums shown here and is not responsible for the content of articles, which is written by their respective authors.