> -----Original Message-----
> increment. Open Office has two optional fields to retrieve generated
> values.
> One for Auto-increment statement, and one for Query of generated values.

GEN_ID(GENERATORNAME, 1) or maybe even SELECT GEN_ID(GENERATORNAME, 1) FROM
RDB$DATABASE for Auto-Increment statement AND
SELECT GEN_ID(GENERATORNAME, 0) FROM RDB$DATABASE for Query of generated
values?

Alternatively you can create a Stored Procedure that takes an argument (in
this case Integer that will be 1 for the first and 0 for the second) that
does the same thing and execute/select from the Store Procedure...
Technically the SP approach is less likely to break in the future.


--
No virus found in this outgoing message.
Checked by AVG Anti-Virus.
Version: 7.0.338 / Virus Database: 267.9.5/58 - Release Date: 7/25/2005