Has it been resolved?
If you are using local SQL, put double quotation mark around alias and
table name, i.e.
select * from ":appdir:sometable"
If SQL is passed throught to some database server, then it depends on the
server. At least Interbase does not recognise alias. I wonder all other
database server will not recognise alias as well.
At 14:30 10/12/99 +1300, you wrote:
>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
>
>
>
--------------------------------------------------------------
Edward Tianjun Huang Today Software Limited
97 Great South Road
Email: [EMAIL PROTECTED] (Company) Remuera
[EMAIL PROTECTED] (Private) Auckland
--------------------------------------------------------------
---------------------------------------------------------------------------
New Zealand Delphi Users group - Database List - [EMAIL PROTECTED]
Website: http://www.delphi.org.nz
