Subject Re: [firebird-support] Re: Autoincremented Fields in Delphi
Author Fabrizio Lozada
Hi There,

I think it's delphi who its checking the constraint.
That you need to do is declare all the fields with the
Fields editor for TQuery and TTable, then change the
required to [False] property and set the
AutoGeneratedValue to [arDefault] or [arAutoInc].


--- Genilton Barbosa <genilton@...> escribió:

Now, I executed INSERT INTO MyTable ... using IBExpert
and it worked
OK. So, there's not a Firebird problem. My software
was developed
using Delphi / BDE / TTable object and I think the
problem is in
there. I will search Delphi / BDE sites.


Genilton Barbosa

--- In, "Martijn
<m.tonies@u...> wrote:
> > I migrated a database from Paradox to Firebird
unsing the
> > tool IBPump. IBPump create generators and triggers
to simulate
> > autoinc fields.
> >
> > The autoinc simulation is not working if the
autoinc fields are
> > in primary keys (NOT NULL constraint). It looks
like the
> > is checked before the execute of the trigger.
> No, they shouldn't be.
> What's the -exact- error message?
> With regards,
> Martijn Tonies
> Database Workbench - tool for InterBase, Firebird,
MySQL, Oracle &
> Server
> Upscene Productions
> Database development questions? Check the forum!


Visit and click the
Resources item
on the main (top) menu. Try Knowledgebase and FAQ
links !

Also search the knowledgebases at



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

To unsubscribe from this group, send an email to:

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


Correo Yahoo!
Espacio para todos tus mensajes, antivirus y antispam ¡gratis!
Regístrate ya -