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?
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
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
not delphi requires this, its the bde and its embedded local SQL
glad to helped you
meikl ;-)
glad to helped you
meikl ;-)
ASKER
Didn't realise that two sets of colons are required in the Delphi components.
Thankyou.