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.