deleteing a record from database using delete_record [message #144985] |
Sun, 30 October 2005 19:28 |
quandom
Messages: 1 Registered: October 2005 Location: Sydney, Australia
|
Junior Member |
|
|
(Oracle9i Form Builder)
From my understanding, in a generic delete button thats in a specific datablock, when you create a when button pressed trigger to the code:
DELETE_RECORD;
COMMIT;
It will delete the current datablock record from the database...
However in my form, when doing this, it comes up with a message regarding inserting the record...
I assume that since its using the command COMMIT;, it thinks to submit data into the database, where in fact, I'm trying to delete a record.
Is there a way around this? (I guess my question is, is my understanding of deleting a record using Oracle Forms incorrect?)
I have also tried
DELETE FROM CUSTOMER WHERE CUSTOMER_ID = x;
--where x is some variable
COMMIT;
Kind regards,
Drew
|
|
|
|