Link to home
Start Free TrialLog in
Avatar of chunky1
chunky1

asked on

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

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?


ASKER CERTIFIED SOLUTION
Avatar of kretzschmar
kretzschmar
Flag of Germany image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of chunky1
chunky1

ASKER

Brilliant!

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

Thankyou.
not delphi requires this, its the bde and its embedded local SQL

glad to helped you

meikl ;-)