>>Hi,
>>
>>I'm new to VB. I'm using VB and SQL for my app. I can't find a way to detect changes made to a recordset. Would somebody help me on this? Please provide some simple codes. This will be really helpful.
>
>Which changes? Changes made by other users once a recordset is open? You need a server sided cursor (CursorLocation = adUseServer) with a CursorType set to adOpenKeySet or adOpenDynamic.
Sorry that i was't clear on my question. This is my situation. I have created a VB form with a few controls on it. These controls are hooked up to an ADO recordset. In addition, I have a 'save' and 'close' buttons on my form. If an user makes some or no changes to my form, when he/she click on the 'close' button, I want to detect if there are any changes made so that i can prompt him/her.
Thx.
Previous
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only