Home » Developer & Programmer » Forms » how can save record from control block
how can save record from control block [message #254656] Fri, 27 July 2007 06:44 Go to next message
habib.khan
Messages: 20
Registered: March 2007
Location: Islamabad
Junior Member
Hello everyone,
i am using oracle 10g. i have been create a control block in form developer and want to save record into database table.how can i do this.Please give me instructions to do this.
Thanks in advance.
Regards
Muhammad Habib

[Updated on: Fri, 27 July 2007 06:44]

Report message to a moderator

Re: how can save record from control block [message #254708 is a reply to message #254656] Fri, 27 July 2007 11:23 Go to previous message
Littlefoot
Messages: 20888
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
You'd do that as if it was SQL*Plus command line - using the INSERT statement.

When you choose how to do that (for example, using the KEY-COMMIT or WHEN-BUTTON-PRESSED or .. trigger), you'll have to write the complete statement:
INSERT INTO your_table 
  (column1, column2, ...)
   VALUES
  (:control_block.item1, :control_block.item2, ...);

COMMIT;
Previous Topic: How to insert text file(.txt) to oracle database using oracle form 10g?
Next Topic: How to hide dialog window?
Goto Forum:
  


Current Time: Sat Dec 03 05:43:38 CST 2016

Total time taken to generate the page: 0.11137 seconds