Subject RE: [ib-support] Generated ID and constraints
Author Wilson, Fred
Generators are outside of transaction control.

Best regards,
Fred Wilson
SE, Bell & Howell
fred.wilson@... <mailto:fred.wilson@...>

-----Original Message-----
From: szsani [mailto:ssani@...]
Sent: Wednesday, December 19, 2001 9:27 AM
Subject: [ib-support] Generated ID and constraints

Hi all

I have a table with ID, NAME etc fields and numerous check and
foreign key constraints.
I get ID number in before update trigger from a generator.

After making structure in testing time I found following problem.

If any constraint causes an exeption user get error message but my
generator already increased.
Example: If user doesn't set NAME before clicks ok to add new record
check constraint gives a warning.
But how can I prevent my generator from increasing at this time?

Thanks in advance

Sandor Szollosi

Yahoo! Groups Sponsor




To unsubscribe from this group, send an email to:

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