>Hi,
>
>There is something I don't understand un VFP. I colect some data from a free table with a SQL command (SELECT * FROM mytable INTO CURSOR c1) I can get other data from the same table with SQL command into other cursors (c2, c3, ...) but I can't open my table with the USE command, I get error 'File in use'
>
>Is it normal that SQL keep the table open ?
>
>Thanks
>Thierry

Try doing a select from the command window on a table. Then type SET. You will see that the results as well as the table you selected from will be open.

In code you can use the USED() function to see if the table you want to "use" is already open.

HTH