Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
What does SQLEXEC() return after an UPDATE... command?
Message
From
19/10/2004 02:12:35
Km Kwun
Eastop Consultants Limited
Nt, Hong Kong
 
 
To
18/10/2004 13:34:30
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00951936
Message ID:
00952508
Views:
6
Aleksey,

Thanks for the information!

KM


>>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
Reply
Map
View

Click here to load this message in the networking platform