Solved

How can I execute an SQL covering two paradox alias's

Posted on 2001-09-17
3
245 Views
Last Modified: 2010-04-06
I have the following SQL statement which looks a two databases in two different alias's.

The first table "Version" is in a paradox alias called "cust".

The second table "Versions" is in a paradox alias called "Cust_control".

The Version_type=Version_id links the records in each of the databases.

select Version,version_desc from :cust:version, :cust_control:versions
where Cust_id="47359"
and version_type=version_id

This SQL correctly works within Database explorer, but if I try to run the same statement within an SQL component in delphi I get the error "Invalid use of keyword. token:?, "

Can anyone help me please?


0
Comment
Question by:chunky1
  • 2
3 Comments
 
LVL 27

Accepted Solution

by:
kretzschmar earned 20 total points
ID: 6487584
select * from
::AliasName1::Tablename1 t1,::AliasName2::Tablename2 t2
where t1.field = t2.field

do not provide a databasename in your query-property

meikl ;-)
0
 
LVL 1

Author Comment

by:chunky1
ID: 6487703
Brilliant!

Didn't realise that two sets of colons are required in the Delphi components.

Thankyou.
0
 
LVL 27

Expert Comment

by:kretzschmar
ID: 6488217
not delphi requires this, its the bde and its embedded local SQL

glad to helped you

meikl ;-)
0

Featured Post

Netscaler Common Configuration How To guides

If you use NetScaler you will want to see these guides. The NetScaler How To Guides show administrators how to get NetScaler up and configured by providing instructions for common scenarios and some not so common ones.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
Delphi TcxGrid group footer summary 3 273
How to build JSON File in Delphi 6 3 34
Wincontrol not (correctly) drawn 15 38
firemonkey keyboard covers the controls 1 26
The uses clause is one of those things that just tends to grow and grow. Most of the time this is in the main form, as it's from this form that all others are called. If you have a big application (including many forms), the uses clause in the in…
In my programming career I have only very rarely run into situations where operator overloading would be of any use in my work.  Normally those situations involved math with either overly large numbers (hundreds of thousands of digits or accuracy re…
Email security requires an ever evolving service that stays up to date with counter-evolving threats. The Email Laundry perform Research and Development to ensure their email security service evolves faster than cyber criminals. We apply our Threat…
Finds all prime numbers in a range requested and places them in a public primes() array. I've demostrated a template size of 30 (2 * 3 * 5) but larger templates can be built such 210  (2 * 3 * 5 * 7) or 2310  (2 * 3 * 5 * 7 * 11). The larger templa…

810 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question