Posted on: 9/29/2014 9:45:30 PM | Views : 429

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 ...