Home » Developer & Programmer » Forms » how to generate sequence value in forms field (forms 6i)
how to generate sequence value in forms field [message #436611] Thu, 24 December 2009 08:10 Go to next message
sivaora
Messages: 119
Registered: October 2009
Location: Hyderabad
Senior Member
i have created a sequence in oracle 9i.
And i Created a form for a table and i want to use the next sequence value in form field.
so i write code in when-new-block-instance and assigning sequence next value into text item t1.
But when saving my form the sequence has to generate the next value when not saving the form and quiting then the sequence need not to generate the next value, the same sequence value has to be generated when reopening the form.
How to do it.
Please reply me soon.

Report message to a moderator

Re: how to generate sequence value in forms field [message #436635 is a reply to message #436611] Thu, 24 December 2009 16:46 Go to previous messageGo to next message
Littlefoot
Messages: 21823
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
Do you store sequence values into the table? (i.e. is the "sequence" form item a database item?) If so, "reopening" the form means "executing a query" and, in that case, you'd simply fetch previously stored sequence values.

However, if you'd just want to display that sequence number in a form (but not store it into the database), you don't even need the sequence (database object): just display :SYSTEM.TRIGGER_RECORD system variable.

Report message to a moderator

Re: how to generate sequence value in forms field [message #437742 is a reply to message #436611] Tue, 05 January 2010 22:18 Go to previous message
djmartin
Messages: 10181
Registered: March 2005
Location: Surges Bay TAS Australia
Senior Member
Account Moderator
Did the answer that you received solve your problem?

David

Report message to a moderator

Previous Topic: button icons on form 10g +form services
Next Topic: How to call a Report from a Menu in Forms 6i (merged 4)
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Mon Feb 10 05:11:08 CST 2025
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.