Maybe just to extract the path from the TDatabase and hardcode it into your
SQL - the Local SQL documentation is pretty useless for that sort of thing.
> -----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
