Home » Developer & Programmer » Forms » About insertion
About insertion [message #212720] Mon, 08 January 2007 00:00 Go to next message
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 #212725 is a reply to message #212720] Mon, 08 January 2007 00:28 Go to previous messageGo to next message
vamsi kasina
Messages: 2107
Registered: October 2003
Location: Riyadh, Saudi Arabia
Senior Member
What is the problem in that?
Have you created the data block also manually?
If so, set the Database Data Block property of the block to Yes.

If you have already done this, please elaborate your problem.

By
Vamsi
Re: About insertion [message #212729 is a reply to message #212720] Mon, 08 January 2007 00:36 Go to previous messageGo to next message
myclassic
Messages: 127
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 Go to previous messageGo to next message
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 Go to previous message
djmartin
Messages: 10180
Registered: March 2005
Location: Canberra ACT 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
Previous Topic: solution of frm-41830
Next Topic: Installing forms developer 6i on windows 2003
Goto Forum:
  


Current Time: Sun Dec 04 04:16:54 CST 2016

Total time taken to generate the page: 0.10179 seconds