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