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

Regards


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

Thanks.

Genilton Barbosa
Brazil


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

>
>
>
> > I migrated a database from Paradox to Firebird

unsing the
migration

> > tool IBPump. IBPump create generators and triggers

to simulate

> > autoinc fields.
> >
> > The autoinc simulation is not working if the

autoinc fields are
used

> > in primary keys (NOT NULL constraint). It looks

like the
constraint

> > 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 &
MS SQL

> Server
> Upscene Productions
> http://www.upscene.com
> Database development questions? Check the forum!
> http://www.databasedevelopmentforum.com

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

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


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

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

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 - http://correo.yahoo.com.mx/