[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now

x
?
Solved

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

Posted on 2001-09-17
3
Medium Priority
?
295 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 60 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

What does it mean to be "Always On"?

Is your cloud always on? With an Always On cloud you won't have to worry about downtime for maintenance or software application code updates, ensuring that your bottom line isn't affected.

Question has a verified solution.

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

A lot of questions regard threads in Delphi.   One of the more specific questions is how to show progress of the thread.   Updating a progressbar from inside a thread is a mistake. A solution to this would be to send a synchronized message to the…
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…
We’ve all felt that sense of false security before—locking down external access to a database or component and feeling like we’ve done all we need to do to secure company data. But that feeling is fleeting. Attacks these days can happen in many w…
Despite its rising prevalence in the business world, "the cloud" is still misunderstood. Some companies still believe common misconceptions about lack of security in cloud solutions and many misuses of cloud storage options still occur every day. …
Suggested Courses

872 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