How can I execute an SQL covering two paradox alias's
Posted on 2001-09-17
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
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?