>I have SET EXCLUSIVE OFF in my main program.
>
>I have some PRIVATE DATASESSIONS but not all just becuase I forgot to do so. The code I referenced is in the CLICK METHOD of my FORM.
>
>The TABLES were open SHARED AGAIN IN 0 in the main program.

SET EXCLUSIVE is mapped to the datasession. But it's default is ON for the main datasession, and OFF for PRIVATE datasessions.

Whatever, in no case do I get the table that was the source of a SQL SELECT changing from SHARED to EXCLUSIVE. Run the debugger and breakpoint before and after your SELECT statement and see what the status of your files are before/after.