auto generating a serial number on a form's multi record block [message #304388] |
Wed, 05 March 2008 01:01  |
athar.fitfd@hotmail.com
Messages: 193 Registered: October 2007 Location: pakistan
|
Senior Member |
|
|
Hi every one on the forum.
I want to create a serial number on my form .
i want to create multiple records before saving them. and the serial no should be increased by one when i create the next record before saving the previous record.
The following query works well when i save record before creating any further record.
select nvl(max(sr_no),0)+1 into :sr_no from table_name;
but i want to show this effect before saving any record.
i hope you genius people understand my problem.
i will be very thankful to you for any idea or solution.
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|