----- Original Message -----
From: "alanpltse" <alanpltse@...>
To: <IBObjects@yahoogroups.com>
Sent: Wednesday, November 23, 2005 10:36 PM
Subject: [IBO] ID Generator


>I have created a generator for the ID column of my table Employee.
> How do I do to the generator to make it get the latest number to
> insert into the table. Use trigger? How to define the trigger ?
>
> Case 1: use table new record
> Case 2: use query insert statement.
>
>
>
>
>
>
>
> ___________________________________________________________________________
> IB Objects - direct, complete, custom connectivity to Firebird or
> InterBase
> without the need for BDE, ODBC or any other layer.
> ___________________________________________________________________________
> http://www.ibobjects.com - your IBO community resource for Tech Info
> papers,
> keyword-searchable FAQ, community code contributions and more !
> Yahoo! Groups Links
>
>
>
>
>
>
one simple way, if not concerned about aadit sequnced ...
TIBOQuery.GeneratorValue ("GeneratoName".1)