OraFAQ Forum: Forms » resetting serial number

Home » Developer & Programmer » Forms » resetting serial number (Windows XP Oracle Forms 6i,)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

resetting serial number [message #317067]

Tue, 29 April 2008 06:59

*munnabhai*
Messages: 157
Registered: March 2008
Location: Riyadh

Senior Member

I have one column SL_No i have created sequence and its working fine starts from 1.2.3.4 so n so

whenever im inserting record in a new form the sequence will start fromt he next number example 5.6.7.

i want this sequence will restart from 1.2.3.4 everytime when new record instance.

how can i do this?

Regards

Report message to a moderator

Re: resetting serial number [message #317074 is a reply to message #317067]

Tue, 29 April 2008 07:15

Littlefoot
Messages: 21826
Registered: June 2005
Location: Croatia, Europe

Senior Member
Account Moderator

Quote:

i have created sequence

Do you mean an Oracle object? (created by CREATE SEQUENCE ...)? If so, hm, that's not a very good idea. Because, you might alter sequence (or even drop and create, with certain drawbacks) to start from 1 again but - that would work for a single user. What would you do in multi-user environment? Users would alter this sequence one after another and it would be a complete mess.

I'd suggest you to abandon this approach and use :SYSTEM.TRIGGER_RECORD instead; it might do what you are looking for.

Report message to a moderator

Re: resetting serial number [message #317190 is a reply to message #317067]

Tue, 29 April 2008 20:41

djmartin
Messages: 10181
Registered: March 2005
Location: Surges Bay TAS Australia

Senior Member
Account Moderator

Have you considered using the block property 'current_record' in the block level 'pre-insert' trigger to populate 'sno' when the user saves their data. What do you want to do with the value in 'sno' when the user updates a set of records and inserts one in the middle?

David

Report message to a moderator

Previous Topic:	Loop Problem
Next Topic:	FILE_OPEN_DIALOG question

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Tue Sep 09 14:27:05 CDT 2025