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
To: ib-support@yahoogroups.com
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

ADVERTISEMENT

<http://rd.yahoo.com/M=178320.1681224.3270152.1261774/D=egroupweb/S=17050077
09:HM/A=879171/R=0/*http://www.fastweb.com/ib/yahoo-57f>

<http://us.adserver.yahoo.com/l?M=178320.1681224.3270152.1261774/D=egroupmai
l/S=1705007709:HM/A=879171/rand=280357994>

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



Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service
<http://docs.yahoo.com/info/terms/> .