Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss

More on How to use Trigger for auto-increment fields

1 view
Skip to first unread message

pcerdaz

unread,
Sep 17, 2007, 2:05:25 PM9/17/07
to
A few days ago I had some problems to use triggers for auto-increment
fields, but it was solved using two indications:

1. The correcto use of trigger sentence is: "new.CODIGOFACTURA =
GEN_ID(G_CODIGOFACTURA, 1);"

2. On VLC side I set the required property to false for the auto-increment
field

but now I have a problem with one table in wich the auto-increment field is
not working; I'm using the same indications and application is not showing
any error message but the register is not posted. I already did a review of
all different properties and made a comparison with other tables but I don't
understand where is the problem.

The application can insert an empty register and populate it, but after I do
the post() method, either with navigator button or with a coded instruction
as "DMTEC->IBDS_Ingredientes->Post()", the database do not have the new
record.

Do you help me to understand what is happend?
Regards,
pcerdaz


0 new messages