Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Does NEEDUPDATE() require exclusive use of table
Message
General information
Forum:
Visual FoxPro
Category:
Stonefield
Miscellaneous
Thread ID:
00489180
Message ID:
00489496
Views:
11
You are correct in that exclusive use is not needed to check if an update is needed.

If you are still getting true, then at least 1 table did not get updated. Right before you do the update, call the oMeta.ResetError method to clear any old error messages. After the update completes, check the oMeta.lErrorOccurred property. If it is true, the error message stuff will be in the oMeta.aErrorInfo array property.

My guess is you have a table with a bad PK index. There will be 2 or more records with duplicate corrupted key values. Once you fix that data, the update will complete without error.

>Correction, I've already upgraded to 5.1i and am still getting a TRUE from NEEDUPDATE() when a file is in use and not really different.
>
>-- Larry
>
>
>>Mark,
>>
>>Thanks for the reply. I'm using version "G" I believe, so I'll check out "I". It makes sense that the actual updating requires exclusive use, but I didn't see why NEEDUPDATE() would (just checking for differences). It sounds like you are saying in version "I" exclusive use is not required.
>>
>>-- Larry
Mark McCasland
Midlothian, TX USA
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform