Subject Re: [firebird-support] Firebird and OpenOffice
Author Martijn Tonies

> Has anyone figured out how to get generators working with OpenOffice
> so that you can use the data pilot as a frontend? OO throws an
> error when you don't explicitly enter a value for a generated
> integer primary key -- which is to be expected.
> Lack of support for Firebird's generators is the only problem I've
> found with using OO, Firebird, and ODBC.

Change your trigger to:

IF ( (NEW.idcolumn IS NULL) or (NEW.idcolumn = 0 )
THEN NEW.idcolumn = GEN_ID...

And enter "0".

With regards,

Martijn Tonies
Database Workbench - developer tool for InterBase, Firebird, MySQL & MS SQL
Upscene Productions