OraFAQ Forum: Forms » Insert value into table from form using sequence(Auto Generated NO)

Home » Developer & Programmer » Forms » Insert value into table from form using sequence(Auto Generated NO)

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

Insert value into table from form using sequence(Auto Generated NO) [message #226514]

Sat, 24 March 2007 08:25

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

Report message to a moderator

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

djmartin
Messages: 10181
Registered: March 2005
Location: Surges Bay TAS 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

Report message to a moderator

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

rdhaprakasam
Messages: 37
Registered: February 2007
Location: Coimbatore

Member

thanks david i`ll try and tell you soon

Report message to a moderator

Previous Topic:	regarding forms
Next Topic:	Text items and custom cursors (web Forms) - Possible solution

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Feb 13 00:31:40 CST 2025