AFAIK this is a scoping issue - some aliases are more global than others. I
can't remember the flags offhand - but you can make a temporary alias act
like a static one and should be able to get at it in SQL even without saving
them.
Max
-----Original Message-----
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED]]On Behalf Of Derricutt, Mark
Sent: Friday, 10 December 1999 14:31
To: Multiple recipients of list database
Subject: [DUG-DB]: Aliases in queries...
A small question about specifying aliases in sql statements, in my app I'm
creating an alias called APPDIR on the fly, if I have a TQuery and set its
DatabaseName property to APPDIR I can access the tables there fine.
But... if I have a query with the DatabaseName set to STEAMFIELD (the
usual) and try something like "select * from :appdir:sometable" I just get
errors, access viols, and all sorts of weirdness, is there some magic way of
handling this?
Mark
--
Mark Derricutt
"People in prayer for me, everyone there for me, sometimes I feel I should
face this alone, my soul exposed... It calm's me to know that I won't!"
Dream Theater - Scarred
Now Playing: Axxis - Stay Don't Leave Me
---------------------------------------------------------------------------
New Zealand Delphi Users group - Database List - [EMAIL PROTECTED]
Website: http://www.delphi.org.nz
---------------------------------------------------------------------------
New Zealand Delphi Users group - Database List - [EMAIL PROTECTED]
Website: http://www.delphi.org.nz
