Re: Parameterized Query No rows affected

It is the parameter in the subquery that is causing the problem. Can anyone
tell me what ADO (or Jet data provider) does with parameters that would
explain this?

This sucessfully affects rows

UPDATE MyTable
SET field1 = :Param1
WHERE field2 = :Param2 AND
NOT EXISTS (SELECT field21 FROM MyTable2
WHERE (field21=field1) AND (field22 <> 11) )

parameters[0].value := 9;
parameters[1].value := 3000;

but

UPDATE MyTable
SET field1 = :Param1
WHERE field2 = :Param2 AND
NOT EXISTS (SELECT field21 FROM MyTable2
WHERE (field21=field1) AND (field22 <> :Param3) )

parameters[0].value := 9;
parameters[1].value := 3000;
parameters[2].value := 11;

does not. Why?

Dave


.