>So select-sql opens tables directly from disk on a new workarea, and doesn't use the cursor of the table actualy opened ?

I don't know if this is going to be simple. If it is already opened then keep in mind table buffering. If it is not open then it reads off the server directly. I am not sure exactly how the schemem will work & it could change with different versions of FoxPro.

Tom