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 21:58:45 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. Reordering of key fields leads to key violations (Pdox 5.0)

4. Paradox Key Violation - changing a keyed field

5. Jet AutoNumber fields and Key Violations

6. Q: Primary key constraint violation with datetime field

7. Key field violation when comparing two tables

8. KEY VIOLATION on AUTOINCREMENT field ?!?

9. Indentity field causing primary key violation

10. key violation error with autoinc field

11. Key Violation on Autoincrement field

12. Key violation & autoincrement fields


 
Powered by phpBB® Forum Software