| how can save record from control block [message #254656] |
Fri, 27 July 2007 06:44  |
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  |
 |
Littlefoot
Messages: 21823
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; |
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
