>>>Every now and then I perform SQL Selects within an event method. The trouble is that by using
>>>the table name I am not pointing in the same place as the registry. I have had no luck when
>>>performing the SQL Selects against a view.
>>
>>Can you specify what you mean with the relation of SQL and registry?
>I mean that when running an application for the first time it asks where the data is located and it stores that information in the Windows registry. This data location need not be a subdirectory of the directory in which the project or executable resides. But, when I run an SQL Select it goes against tables that are found in the path created at startup time, spcidifcally in the DATA subdirectory.
It's safer to have tables opened before you call Select-SQL. This case it will always perform against opened tables regardless what other tables might be located on default path.
Edward Pikman
Independent Consultant