DAO error code 0xbf5

[Former Member]

I am getting the below error in my crystal reports 9 query

Not Supported

Details: DAo error code 0xbf5

Source: DAO.Database

Description: Too few Parameters. Expected 2

The Query is as given below.

SELECT

Transactions.DocID,

Transactions.Quantity,

Transactions.Rate,

Items.ItemName,

Items.Unit,

PO.Po_ID,

PO.Po_Date,

PO.QuoteNum,

PO.PayTerms,

PO.DeliveryDate,

PO.VAT,

PO.SrvcTax,

PO.Amount,

Suppliers.SName,

Suppliers.Address1,

Suppliers.Address2,

Suppliers.City,

Customers.CName,

Customers.Address1,

Customers.Address2,

Customers.City

FROM (((Transactions INNER JOIN Items

ON Transactions.ItemID = items.ItemID)

LEFT JOIN PO

ON Transactions.DocID = PO.Po_ID)

LEFT JOIN Suppliers

ON PO.SuppID = Suppliers.SID)

LEFT JOIN Customers

ON PO.CustID = Customers.CustID

Where Transactions.DocID = {?poID}

If i hard code a poID then it says - Too few Parameters. Expected 1.

Can you help. I am not able to make out which value is missing.

Many thanks and regards

[former_member11696]

Hello,

Unfortunately CR 9 and all of it's available patches are no longer available. Possible some patch may have resolved the issue.

What you may want to do is create a System DSN in ODBC administrator and see if that works. Otherwise only option is to upgrade to CR 2008 or above.

Don