Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Remote View, Table Buffering problem VFP6, MSSQL7
Message
From
21/12/1998 13:20:22
 
 
To
20/12/1998 20:16:42
Brian Lee
World Access Network, Inc.
Vancouver, Washington, United States
General information
Forum:
Visual FoxPro
Category:
Client/server
Miscellaneous
Thread ID:
00169205
Message ID:
00169388
Views:
20
>Josh, thanks for your reply. I did notice the documentation for TABLEUPDATE(1), and tried it, no such luck. It still does not update all rows. I also tried using the lForce parameter, TABLEUPDATE(1,.T.) which should force the update. Same thing, returns .T. and there are still uncommitted changes, to other rows!

Hi Brian:
Just a thought, try TABLEUPDATE(2, .T., {Alias}, cErrorArray). The documentaion states that VFP will attempt to commit all records even if an error occurs. With the 1 parameter VFP stops processing as soon as an error is encountered. Perhaps VFP is simply not reporting an error. Setting the first parameter to 2 would eliminate this possibility. You could also examine cErrorArray after the call, just in case it contains more information.

Hope this helps,
Ned

To quote another member: "Free Advice worth at least what you paid."
Ned

Reality is.
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform