>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
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only