Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
TableUpdate() problem on RV's w/ Table buffering
Message
 
To
26/11/2001 22:43:57
General information
Forum:
Visual FoxPro
Category:
Client/server
Miscellaneous
Thread ID:
00585473
Message ID:
00586705
Views:
36
>Thanks Mark - yes, re-setting the FetchSize property to -1 as you suggest, does seem to prevent the timing out. However it still leaves my main issue:
>
>> HERE is the problem: TABLEUPDATE(1,.T.) returns .T. indicating that
>> "changes to all records are committed". However, upon checking the
>> table in SQL Query Analyzer, some or all of the data has NOT been committed!!!
>>

Tableupdate with the first parameter as 1 only updates 1 row. This is per the manual.

>Even more! I can tweak CursorSetProp('BatchUpdateCount', 100, 'VIEW'), which is supposed to "greatly increase update performance" according to Help.
>
>In fact, adjusting this value now causes TableUpdate() to update ONE row at a time!! Instead of ALL rows, as the RV is set for Table Buffering.

The default behavior of tableupdate is to update the current record. If you want to do a forced update of all records, do TABLEUPDATE(.T.,.T.) which should at least attempt to update all the records.
Cy Welch
Senior Programmer/Analyst
MetSYS Inc
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform