Community
Showing results for 
Search instead for 
Do you mean 
Reply

Parameters for SQL statements and connection strings

New Member
Posts: 3
Country: Poland

Parameters for SQL statements and connection strings

Hello

I was wondering whether threr are some preset parameters that can be used in SQL statements or connection stings. For now I am interested in currently logged user and database file folder.

Say i want to SQL access some file within templates folder. Of course the path will differ for all remote user and adjusting it for everybody is not suitable. Therefore I would like to adjust my connection string so that it works on all computers by means of including target=[database folder]\templates etc. Is that possible?

In my SQL statement I would like to filter the data depending on currently logged user. Can I include in the statement something like where user=[current user].

i am using mainly OLEDBGRID - great tool but I am not sure whether it gives such abilities. 

Tomek
www.gemini.sc