BorlandTalk.com

Ross B. · Guest

It seems if I have a nested query such as

SELECT
...
FROM
...
INNER JOIN...
WHERE
ID IN (
SELECT ..
FROM AnotherDatabase.dbo.Table
WHERE
AnotherID= :pID
)
...

The pID never gets popultaed when I add a value to
parameters.parambyname('pID').Value. I ran a debug on the TStrings of the
SQL and :pCID never recieves the value it is always the value 'pID'. I have
made sure that the parameters for the TADOQuery are proper and at design
time I can open the query. Has anyone seen this.. Does it have something to
do with running against 2 DB's????

Thanks,
Ross B.

Bill Todd (TeamB) · Guest

Parameters are not replaced by the VCL components. The query and the
parameter values are sent to the database server separately. Note that
it is usually impossible to provide good answers to database questions
when you do not tell us what database you are using. You might also
have better luck with this question in the ADO newsgroup.

--
Bill (TeamB)
(TeamB cannot respond to questions received via email)