Luc You can not issue an INDEX command when the table is opened as SHERED. INDEX ON... requests EXCLUSIVE use of the table.


>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