Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
CursorAdapter with TimeStamp
Message
From
29/09/2003 12:21:59
 
 
To
25/09/2003 04:11:51
Metin Emre
Ozcom Bilgisayar Ltd.
Istanbul, Turkey
General information
Forum:
Visual FoxPro
Category:
Other
Miscellaneous
Thread ID:
00831096
Message ID:
00833197
Views:
18
Thanks Metin for your suggestion.
The reason why I am using timestamp is a limitation with SQL Server. In order to check if some user changed the record, VFP includes in the WHERE clause for UPDATE, the ModifiedFields, the problem you have if you change a Memo field, in this case SQL doesn´t allow text fields in where clause using "=". So, in case I have to turn off the option to "Compare Memo Field", then VFP will not include memo fields in where clause. But, if I do that, VFP allow you to overwrite the changes made by other user. That´s why we decided to use timestamp fields.

It is make sense for you?
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform