Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Temporary index in buffer mode
Message
General information
Forum:
Visual FoxPro
Category:
Troubleshooting
Title:
Temporary index in buffer mode
Environment versions
Visual FoxPro:
VFP 6 SP3
OS:
Windows XP
Database:
Visual FoxPro
Miscellaneous
Thread ID:
00957281
Message ID:
00957281
Views:
47
Hi, I Got a problem creating a sample TEMPORARY index
The index key is based on user entry so this is why I create a temp. index

See code below!

LOCAL X AS Session

USE C:\SOMETABLE SHARED
SET ORDER TO 1
CURSORSETPROP("Buffering",4)
? CURSORGETPROP("Buffering",4) &&--> 4 OK

X=CREATEOBJECT("SESSION") && TO SIMULATE A FORM (PROBLEME AS WELL WITH A FORM)
SET DATASESSION TO X.DataSessionID

USE C:\SOMETABLE SHARED AGAIN
? CURSORGETPROP("Buffering") && --> 1 OK


INDEX ON SOMEFIELD TO C:\TEMPIDX.IDX
--> ERROR : Command cannot be issud on a table with cursors in table
buffering mode

This is ok when buffering mode 4 or 5 but why in the second datasession
Why that doesn't work ?
Any work arrond (other than remove the buffering temporary in the first datasession) ?


Thank for your help

Luc St-Pierre
Next
Reply
Map
View

Click here to load this message in the networking platform