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.
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: 20825
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.
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: 10180
Registered: March 2005
Location: Canberra ACT Australia
Senior Member
Account Moderator
Did the answer that you received solve your problem?

David
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:
  


Current Time: Mon Sep 26 02:34:31 CDT 2016

Total time taken to generate the page: 0.07825 seconds