vnarod Posted March 21, 2003 Posted March 21, 2003 Can I somehow get row before update (using ExecuteNonQuery) command changes it? I need to save previous value in log table Quote
a_jam_sandwich Posted March 21, 2003 Posted March 21, 2003 Run a INSERT with the values before the update then run the update 2 Querys Andy Quote Code today gone tomorrow!
*Experts* Nerseus Posted March 22, 2003 *Experts* Posted March 22, 2003 If you're using a DataSet, you can get at both the original data and the changed data. Perform you action (INSERT, UPDATE, DELETE) but don't call AcceptChanges. Use the DataSet to figure out what the action was and how to log it. -Nerseus Quote "I want to stand as close to the edge as I can without going over. Out on the edge you see all the kinds of things you can't see from the center." - Kurt Vonnegut
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.