| About insertion [message #212720] |
Mon, 08 January 2007 00:00  |
romi
Messages: 67
Registered: October 2006
|
Member |
|
|
Hello all,
i am new in forms.I am using forms 9i.i have made manually a form. and i have made a table related to that form in ooracle 9i.now i want to insert all values of that form into table, can anyone help me how can i do it?
thanks in advance.
|
|
|
|
|
|
| Re: About insertion [message #212729 is a reply to message #212720] |
Mon, 08 January 2007 00:36  |
myclassic
Messages: 136
Registered: December 2006
Location: Pakistan
|
Senior Member |
|
|
use this command
insert into tablename (column1,column2,column3,column4)
values (:Blockname.column1,:Blockname.column2,:Blockname.column3,:Blockname.column4);
Commit;
you may use this behind any button or on commit trigger etc.
take care.
|
|
|
|
| Re: About insertion [message #212734 is a reply to message #212725] |
Mon, 08 January 2007 01:13 |
romi
Messages: 67
Registered: October 2006
|
Member |
|
|
Yes, I have done all this, but when i pressed save button, it doesn't save or do not give any error massage.
Plz tell me what i have to do.
|
|
|
|
| Re: About insertion [message #213213 is a reply to message #212734] |
Tue, 09 January 2007 18:32 |
 |
djmartin
Messages: 10181
Registered: March 2005
Location: Surges Bay TAS Australia
|
Senior Member
Account Moderator |
|
|
Aaahhh!! Please, please, PLEASE - just base your block on the table and Oracle Forms WILL do ALL the rest.
Create a new form, use the block wizard and point to the Oracle table, generate and run the form. It will do all the basic processing that is required.
DO NOT DO THIS MANUAL CRAP!!! If you want to 'handle everything myself' then use VB or .Net, please just don't bastardise Oracle Forms.
David
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
