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
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.
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
Messages: 20847
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, ...)
  (:control_block.item1, :control_block.item2, ...);

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: Thu Oct 27 23:36:54 CDT 2016

Total time taken to generate the page: 0.05784 seconds