My project is an orders application, where users can enter orders from different customers, using an
to enter and edit data. When the Delete key is pressed on the keyboard, it prompts a
for the user to confirm they want to delete the selected row, and if so, it runs a
query to delete that row from the database.
I also have a Save button to allow the user to save the order/changes made to the order. Ideally, I only want the row in the grid to delete temporarily as, if the user then doesn't save the order, the order line shouldn't be deleted permanently from the database.
If I put the
query into a separate subroutine, can I then call this subroutine from my class that is saving it as part of the transaction?
This seems like it isn't going to work, as I'd not only need to call the query, but also somehow store the deleted row somewhere temporarily so that it knows which data to delete in the transaction, as well as a
variable to tell it whether there is even any data to delete...
Are there any simpler ways of doing this? Would the above way even work?