Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Temporary index in buffer mode
Message
From
03/11/2004 07:34:10
 
General information
Forum:
Visual FoxPro
Category:
Troubleshooting
Environment versions
Visual FoxPro:
VFP 6 SP3
OS:
Windows XP
Database:
Visual FoxPro
Miscellaneous
Thread ID:
00957281
Message ID:
00957509
Views:
17
>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

This is a old bug.

VFP open a single File handle for any table,
and it shared it into the different datasessions.
When some workareas for this shared handle have a tablebuffer,
VFP see this setting into all the others workareas on all the datasessions.

Then, uses a datasession it is not like uses a different process.

Fabio

PS you can remove the AGAIN because you are into a different datasession.
Previous
Reply
Map
View

Click here to load this message in the networking platform