Results 1 to 3 of 3
  1. #1
    Join Date
    Jan 2004
    Location
    Claremont, CA
    Posts
    38

    Unanswered: Delphi ADO Parameter Query

    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.

  2. #2
    Join Date
    Sep 2003
    Location
    Penang, Malaysia
    Posts
    9

    Re: Delphi ADO Parameter Query

    Originally posted by acabrera
    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...

  3. #3
    Join Date
    Jan 2004
    Location
    Claremont, CA
    Posts
    38
    You are right. What I did was remove the parameter clause, add the fields and then add the parameter clause. Thanks.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •