Article #20420: Parameter "ParamName" Not Found error when using an ADOQuery and Parameters
Question:
When using an ADOQuery with Parameters, and trying to access the Parameters with: ADOQuery.Parameters.ParamByName('ParamName').Value I get a 'Parameter "ParamName" Not Found' error. How can I fix this?
Answer:
You can easily fix this by creating the parameters before calling ADOQuery.Parameters.ParamByName('ParamName').Value by calling: ADOQuery.Parameters.ParseSQL(ADOQuery.SQL.Text, True).