>I guess I have never noticed that all of my SELECT -SQL statements end up using the tables EXCLUSIVE. THis is fine if you are closing them afterward but that is not the case in some of them. THey are using tables that are already opened SHARED. Here's an example:
>
>m.dStartDate={07/28/2000}
>m.dEndDate={07/28/2000}
>
>SET STAT BAR ON
>
>
>SELECT ach_final.*;
> FROM ach_final ;
> WHERE BETWEEN(TTOD(ach_final.cleared), m.dStartDate, m.dEndDate) ;
> ORDER BY ach_final.bankname, ach_final.settdate, ach_final.mid ;
> INTO TABLE ach_final1.DBF
>
>The ach_final file is already opened shared. IT then opens it exclusive. It's driving me crazy. It does the same to the ach_final1 table.
>
>Any ideas as to why this is happening?
>
>Thanks for your support in advance! :-)
Are you using PRIVATE DATASESSIONS? SET EXCLUSIVE OFF in your form's Load method, or in your DE BeforeOpenTables should cure this. How are you opening your tables shared? I've never run into any problems like this, but then I ALWAYS make sure I have my tables that SQL is going to use open before I do the SQL.