Solved

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

Posted on 2001-09-17
3
255 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

Free Tool: Port Scanner

Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

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

Suggested Solutions

Objective: - This article will help user in how to convert their numeric value become words. How to use 1. You can copy this code in your Unit as function 2. than you can perform your function by type this code The Code   (CODE) The Im…
Have you ever had your Delphi form/application just hanging while waiting for data to load? This is the article to read if you want to learn some things about adding threads for data loading in the background. First, I'll setup a general applica…
With Secure Portal Encryption, the recipient is sent a link to their email address directing them to the email laundry delivery page. From there, the recipient will be required to enter a user name and password to enter the page. Once the recipient …
A short tutorial showing how to set up an email signature in Outlook on the Web (previously known as OWA). For free email signatures designs, visit https://www.mail-signatures.com/articles/signature-templates/?sts=6651 If you want to manage em…

685 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