Hi Martijn. Can you confirm that you actually have this working
with your OpenOffice installation?

I had tried that too, and get a '[Microsoft][ODBC Driver Manager]
Invalid cursor state' error (using recent snapshot of IBPhoenix
firebird/interbase ODBC driver). Mind you, it *does* enter the
record into the table (that is FB faithfully doing what it is told),
but I can't avoid OO reporting an error with each insert.

--- In firebird-support@yahoogroups.com, "Martijn Tonies"
<m.tonies@u...> wrote:

> Hi,
>
> > 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

> Server.
> Upscene Productions
> http://www.upscene.com