Hi again,

I've tried the various suggestions to no avail. I've now downloaded the Alpha version of Firebird 2, so could you give me any pointers towards creating a global autoincrement field that can work on various tables with different autoincrfement values - assuming that's even possible! ;-)

Thanks for your time, everybody, it ain't easy being a newbie at 57 years of age! ;-)

Robin Davis

----- Original Message -----
From: Ann W. Harrison
To: firebird-support@yahoogroups.com
Sent: Wednesday, July 27, 2005 11:06 PM
Subject: Re: [firebird-support] Re: Connection with Open Office 2


Robin Davis wrote:
>
> ... I can
> even enter data so long as the PK is not an auto increment field.

The short answer is that Firebird generators don't map nicely into the
"auto increment primary key" model. We've got a fix in V2 which allows
a "singleton" insert statement to return values, but for the time being,
there is no good answer.

Regards,


Ann

>
>
>




++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++

Visit http://firebird.sourceforge.net and click the Resources item
on the main (top) menu. Try Knowledgebase and FAQ links !

Also search the knowledgebases at http://www.ibphoenix.com

++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++




------------------------------------------------------------------------------
YAHOO! GROUPS LINKS

a.. Visit your group "firebird-support" on the web.

b.. To unsubscribe from this group, send an email to:
firebird-support-unsubscribe@yahoogroups.com

c.. Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.


------------------------------------------------------------------------------



[Non-text portions of this message have been removed]