1 Reply Latest reply: Jan 4, 2012 11:46 PM by Don Williams RSS

DAO error code 0xbf5

Sushil Dudhalkar
Currently Being Moderated

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

  • Re: DAO error code 0xbf5
    Don Williams
    Currently Being Moderated

    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

Actions