| How to avoid new id generation [message #129913] |
Wed, 27 July 2005 05:13  |
shum
Messages: 17
Registered: July 2005
|
Junior Member |
|
|
when i just open a form new id is generated and without inserting any data i close that form but when i again open it the new id next to previos is generated but i want that when i insert data then id will generate.
example
there are three client 2 client only visit the form while one is entring the data but in data base the 3 id is generated???
but data is entered by one client
what can i do now???
[MOD-EDIT: Changed title]
[Updated on: Wed, 27 July 2005 05:40] by Moderator Report message to a moderator |
|
|
|
| Re: How to avoid new id generation [message #129922 is a reply to message #129913] |
Wed, 27 July 2005 05:45  |
 |
Maaher
Messages: 7065
Registered: December 2001
|
Senior Member |
|
|
If you are asking how to avoid a new id from being generated without inserting:
Create a sequence on the database and let a before row insert trigger fill the id. Those kind of things should be programmed server side.
Gaps however are virtually unavoidable. We've had many discussions about this in the past. But is that really such a big issue?
PS: I've changed the topic title to something relevant. Read the sticky in the newbie forum for posting guidelines.
MHE
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
