Problem in incremental field and when it happens key violation 
Author Message
 Problem in incremental field and when it happens key violation

The topic is the sig. in a chart I have a serial called
field that is incremental, and I have another called field
you GO that it is key primary.    
In an application made in Delphi, when trying to record a
registration with the duplicated primary key, it returns
me the error of Violation of key and it doesn't insert me
anything, Until there all correct one, the problem would
be it arises that when a key violation takes place the
serial field that is incremental it is increased in one
and in fact to the producirce the key violation any
registration is not inserted, for consequence it is not
logical that the incremental field is increased in one for
next time that enters a registration correctly.    
Example.    
1)_ Fields ' serial' incremental type, field GOES type
text and primary key.    
2)_Supongamos that the one finishes registration in the
chart the serial field contain the serial number 1, if I
now tried to enter a registration copy the key violation
he/she takes place, anything is not inserted but
erroneously I am increased the serial field, and if now it
entered a registration correctly he/she would stay all
very alone one that the serial field fries me the I number
2, and it put me the I Number 3.    

Thank you.



Sat, 02 Jul 2005 15:00:16 GMT
 
 [ 1 post ] 

 Relevant Pages 

1. Problem in incremental field and when it happens key violation

2. Reordering of key fields leads to key violations (Pdox 5.0)

3. Paradox Key Violation - changing a keyed field

4. Reordering of key fields leads to key violations (Pdox 5.0)

5. Paradox Autoincrement Fields Cause Key Violation -- Help!

6. Key violation & autoincrement fields

7. Key field violation when comparing two tables

8. Indentity field causing primary key violation

9. KEY VIOLATION on AUTOINCREMENT field ?!?

10. Q: Primary key constraint violation with datetime field

11. Key Violation on Autoincrement field

12. Jet AutoNumber fields and Key Violations


 
Powered by phpBB® Forum Software