>>>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.
As for me, I prefer to store the application information in the server main directory where the data resides. By that, if the application changes location, I only have to update that file instead of having to go in each workstation and change the registry. I prefer to use the registry for local information and not for global information.
My framework then readjust the location of each table found in the form data environment properties to match this location.