Hi Andrew,

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

No, I cannot.

> 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.

Perhaps it's trying to re-read the row after the insert?

Have you tried other ODBC drivers, just to see if the issue isn't
in the driver?

With regards,

Martijn Tonies
Database Workbench - developer tool for InterBase, Firebird, MySQL & MS SQL
Server.
Upscene Productions
http://www.upscene.com

> --- 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".