Home » Developer & Programmer » Forms » Sequence Generation (Forms 9i)
Sequence Generation [message #346844] Tue, 09 September 2008 18:59 Go to next message
former
Messages: 15
Registered: June 2008
Junior Member
Hi,

I have a created a form which is is based on a database of books. Here, the user gets to add books while running the form (dynamically). However, I would like the serial no of each record to get updated i.e. whenever a new record (book details) is inserted, the sr_no should be automatically generated in the database.

Can you pls guide.

thank you
Re: Sequence Generation [message #346848 is a reply to message #346844] Tue, 09 September 2008 20:11 Go to previous messageGo to next message
former
Messages: 15
Registered: June 2008
Junior Member
I have given a Pre-Insert Trigger at block level as follows:

select bookno_seq.nextval into :books.sr_no from dual;

However, I am getting these errors

"Error 201...........identifier 'dual' must be declared"

"Error 0..............SQL statement ignored"

Any guidance on this

thank you
Re: Sequence Generation [message #346881 is a reply to message #346848] Wed, 10 September 2008 00:04 Go to previous message
Littlefoot
Messages: 20900
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
See my reply to your message in this thread.
Previous Topic: Message "Do you want to save change you have made?
Next Topic: FTP from local system to unix
Goto Forum:
  


Current Time: Thu Dec 08 06:21:15 CST 2016

Total time taken to generate the page: 0.13337 seconds