| how control the sequence in forms [message #201201] |
Fri, 03 November 2006 00:48  |
sanjeevapps
Messages: 2
Registered: July 2006
Location: Hyderabad
|
Junior Member |
|
|
hi all,
i have id column in the form which has to generate the sequence number automatically,i have created the sequence in the database and assigned it and is working fine.
But the problem is that either we save the record or not the sequence is generating.so the as soon as we get in to insert mode the number is generated.
i need the sequence to be generated only when i save the record.
can anyone could help out with the situation.
thanks,
sanjeev varma.s.
|
|
|
|
|
|
|
|
| Re: how control the sequence in forms [message #201666 is a reply to message #201545] |
Mon, 06 November 2006 05:04  |
sanjeevapps
Messages: 2
Registered: July 2006
Location: Hyderabad
|
Junior Member |
|
|
hi Martin,
your right,the validation as worked on pre-insert trigger.
but with some errors as per my requirement, are not working on the pre-insert.so i have resolved it using post-insert trigger.
any ways thank you for ur valuable suggestion.
lets keep the rapo going
thanks,
sanjeev varma.s
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
