I am revising the database engine of our Delphi 5-Oracle 8i applications from BDE to ADO but I encounter the message:

'Parameter object is improperly defined. Inconsistent or incomplete information was provided.'

when I try to add the fields to an ADO Query. The problem SQL statement using a parameter is:

SELECT CO_KEY, DETAIL_DATA1 FROM CONTACT_DETAIL
WHERE CONTACT_KEY IS NULL
AND DETAIL_CD = 'PHONE'
AND CO_KEY = :CO_KEY

This works fine in BDE but not in ADO.

I believed this error occur when the paramater :co_key has a null value...

You are right. What I did was remove the parameter clause, add the fields and then add the parameter clause. Thanks.