Code to Update retrieved record in Oracle Forms 6i
In Oracle Forms 6i, can anybody tell me about code to update data retrieved from database, which can be place under When Button Pressed trigger?
Software/Hardware used:
Forms 6i
Software/Hardware used:
Forms 6i
ASKED:
June 26, 2010 8:49 AM
UPDATED:
August 25, 2010 10:33 PM
Answer Wiki:
If the data was retrieved by a 'database' block, you just need to modify the values in the corresponding items (manually or by code). Then, to save the changes you have to call the COMMIT_FORM built-in procedure.
If it is not a database block, you have to execute an UPDATE (SQL) statement.
More details are needed to provide a better answer.
To see all answers submitted to the Answer Wiki: View Answer History.
i want to search a record from datbase in oracle 10g forms.
That’s great, Oracleform00.
Let us know if you have any questions…
Hi Oracleform00,
If you have any questions, please ask a new question in the forum for easier search and answering. Please provide as many details as possible as well.
Thank you!
Melanie
Dear,i have a datablock in which records are being fetched by a cursor.Records are being fetched properly.My question is i have hundereds of record in one fetch.When a new record insert into the table that cursor retrives all the record that is time consuming.I just want that new record should be fetched into the block where already records exists.
Thanks awaiting for the answer if you could please
Regards
Ansari
Hi Umairansari,
To be able to provide an accurate answer we would need to know how those records are being fetched, and how the new record is being inserted.
But you should create a new question, and provide more details. Also, please include some code.