Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Detect database changes or changes made to the recordset
Message
General information
Forum:
Visual Basic
Category:
Other
Miscellaneous
Thread ID:
00386186
Message ID:
00386199
Views:
16
>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.
Éric Moreau, MCPD, Visual Developer - Visual Basic MVP
Conseiller Principal / Senior Consultant
Moer inc.
http://www.emoreau.com
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform