Home » Developer & Programmer » Forms » Insert value into table from form using sequence(Auto Generated NO)
Insert value into table from form using sequence(Auto Generated NO) [message #226514] Sat, 24 March 2007 08:25 Go to next message
rdhaprakasam
Messages: 37
Registered: February 2007
Location: Coimbatore
Member

hi guys,
I have developed an application using forms 9i.. i need your help.. My situation is i have to insert auto generated no(sequence) into table from form(It works nice on database).. But the no is primary key of that table.(EG:-Emp_id of employee table where Emp_id is primary key).. while user entering the value in forms it may hide or protected from enter the value on that field.. after user press the save button on smartbar it generate the no and display the no in field and save.untill user press the clear button form should not clear.. i have tried but it`s not work can anybody help me so that i can finish my final year project .. please reply as soon as possible
Re: Insert value into table from form using sequence(Auto Generated NO) [message #226925 is a reply to message #226514] Mon, 26 March 2007 23:42 Go to previous messageGo to next message
djmartin
Messages: 10180
Registered: March 2005
Location: Canberra ACT Australia
Senior Member
Account Moderator
Make your visible 'sequence' field a display only non-database field and make it a copy of the primary key field in the table. Then, in the pre-commit trigger populate the primary key field and do a 'synchronize' I think the display only field will be populated. If it isn't then you will have to populate it as part of the pre-commit trigger.

I don't understand what problem you are having with the 'clear' button.

David
Re: Insert value into table from form using sequence(Auto Generated NO) [message #227010 is a reply to message #226925] Tue, 27 March 2007 02:16 Go to previous message
rdhaprakasam
Messages: 37
Registered: February 2007
Location: Coimbatore
Member

thanks david i`ll try and tell you soon
Previous Topic: regarding forms
Next Topic: Text items and custom cursors (web Forms) - Possible solution
Goto Forum:
  


Current Time: Mon Dec 05 11:04:44 CST 2016

Total time taken to generate the page: 0.13467 seconds