I have a stored procedure to insert a row in a table when a button is clicked. I used this in testing so that I could click it to run the stored procedure that inserts a row which is actually a copy of the row that the user is viewing but I only want this
to happen if the user makes changes to the row shown in the form view and then clicks the update button. The ultimate goal is to make a copy of the original row by inserting another row in the database after which I allow the user to update the original row.
I'm doing this to have an original and pending row in the table. It all works fine except, of course, I don't want the user to have to click the button to "copy" the row before he updates.
This is probably a kludge but I got it working after a few long, hard days. the update happens via the formview update whereas the insert is performed in a sproc.
The real question I have is can I click the button programma ...
Go to the complete details ...