Главная страница | назад

Article #20420: Parameter "ParamName" Not Found error when using an ADOQuery and Parameters

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?

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).

Last Modified: 03-JAN-00