Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
What does SQLEXEC() return after an UPDATE... command?
Message
From
18/10/2004 13:34:30
 
 
To
18/10/2004 10:30:52
Km Kwun
Eastop Consultants Limited
Nt, Hong Kong
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00951936
Message ID:
00952353
Views:
7
>Records in the backend may be deleted by other users while a cursor is being edited. After changes made to rows of a cursor are sent back to the SQL server via a TableUpdate, we need to check afterward if the expected update has taken place in the backend. I know tricks can be done to get the information. However, it will be handy if we can check a property of the CursorAdapter to see how the backend has been updated (i.e., the number of rows updated).
>

Hi KM,

If all you want is to detect an Update conflict then CursorAdapter can do it for you, check ConflictCheckType property (available in VFP8 SP1). For all other scenarios, simply execute command passed as a parameter in Before... event, get the record count, set the parameter to an empty string.

Thanks,
Aleksey.
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform