🚀 go-pugleaf

"PK" <thekariuki@yahoo.co.uk> wrote in message 
news:4461c82e$1@newsgroups.borland.com...
>
> Hello!
> Am currently converting the database in my appication from
> Interbase(using InterBase Components) to Oracle 8i(Using the 
> ADO
> components).
> Whenever I fill the SQL property of an ADOQuerry with 
> statements
> that have parameters e.g
> "
> SELECT   SB.NAME, SI.VARIETY, SUM(IIT.QTY) 
> ,SUM(IIT.SPRICE*IIT.QTY)
>
> FROM STOCK_BRAND SB, STOCK_ITEM SI, ITEM_IN_TRANSACTION IIT, 
> TRANZACTION T, UZER U
>
> WHERE IIT.RECEIPTNO=T.RECEIPTNO AND
> U.USERID=T.USERID AND
> IIT.BARCODE=SI.BARCODE AND SB.STOCKBRANDID=SI.STOCKBRANDID AND
> T.TRANZDATE BETWEEN :StartDate  AND :StopDate AND
> T.TILLID LIKE :TillID AND
> U.USERNAME LIKE :UserName
>
> GROUP BY  SB.NAME, SI.VARIETY
> ",
> I get an error whenever I try to set Active=true.
> The error is:
> "Parameter object is improperly defined. Inconsistent or
> incomplete information was provided."
> Note that no error occurred when I used an IBQuerry.
>
> This same problem has made it hard for me to access the fields 
> of
> the querries for use in QReports. Whenever I try to accesss the
> DataField property of QRDBEdit whose DataSet is the querry
> described above, I get the same error as above.
>
> Please help me resolve my problem.
>
> Kind regards,
> PK

Are you setting values into your :parameters?

- Arnie