Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Cursor can Not be updated because it contains unsaved re
Message
 
To
24/08/2005 02:15:36
General information
Forum:
Visual FoxPro
Category:
Other
Environment versions
Visual FoxPro:
VFP 8 SP1
OS:
Windows 2000 SP4
Network:
Novell 6.x
Database:
Visual FoxPro
Miscellaneous
Thread ID:
01043169
Message ID:
01043178
Views:
10
>Hello all
>I am get the error mentioned in the title, but NOT if I issue a browse on the table before the offending statements that generate the error. The browse solves the problem. What is puzzling is that I am not using a cursor, it is a table. Setting buffering to 5 and issuing a tableUpdate()does not help. Any ideas
>
>Buffering/update code does not help:
>
>SET MULTILOCKS ON  && Must turn on for table buffering.
>= CURSORSETPROP('Buffering', 5, 'poItems' )  && Enable table buffering
>TABLEUPDATE()
>
Vince,
Tableupdate has a few parameters you can use,
In the code you posted I am not sure what is the curent alias, so try this:
SET MULTILOCKS ON  && Must turn on for table buffering.
=CURSORSETPROP('Buffering', 5, 'poItems' )  && Enable table buffering
TABLEUPDATE(1,.t.,'poItems')
Against Stupidity the Gods themselves Contend in Vain - Johann Christoph Friedrich von Schiller
The only thing normal about database guys is their tables.
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform