Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
TableUpdate(2,.T.,'MyTable', MyArray)
Message
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Miscellaneous
Thread ID:
00092369
Message ID:
00092467
Views:
20
>We're trying to use the Tableupdate() command with the 'Multiple updates and record errors in an array' parameters. It works fine, EXCEPT the errors are never included in the array. All records are updated except the one we deliberately locked on another system. The Tableupdate() returns FALSE, as it should with one record not updated.
>
>We have tried it with the array initialized before the command an with the array opened by the TableUpdate. Either way, it has one record, with a value of FALSE instead of the record # of the unprocessed record.
>
>Multilocks is (are?) on
>Table buffering set to 5
>
>Any suggestions?
>
>TIA,
>Barbara

Hi Barbara,

I do the multiple updates that you are trying to do too. This is all embedded within a transaction class. I don't use the error array though. If a .F. is returned from the =TableUpdate(), then I have an error routine that is checked and it does an AERROR() which seems to work fine. I must admit that that I've not used the error array having developed the class in 3.0 long ago when it wasn't available. But from what the others have said, I think that this is what you might need to do.

Steve
Previous
Reply
Map
View

Click here to load this message in the networking platform