I have been banging my head against the desk on this for a week and am
coming up empty handed.
I have several reports in Crystal Reports 8.5 that are giving me troubles in
the Paradox ODBC layer. I keep getting errors stating "ODBC
error:[Microsoft][ODBC Paradox Driver] Too few parameters. Expected 2"
I think that the problem is related to the Crystal-generated SQL, but I'm
not sure. For example one SQL statement looks like this:
When I change the WHERE clause to be Customer_Co0, I get the same error
excpet it is "Expected 1" instead of 2.
I am getting desperate to get a fix for this, so any advice you can pass my
way would be appreciated.
Thanks!
Josh
coming up empty handed.
I have several reports in Crystal Reports 8.5 that are giving me troubles in
the Paradox ODBC layer. I keep getting errors stating "ODBC
error:[Microsoft][ODBC Paradox Driver] Too few parameters. Expected 2"
I think that the problem is related to the Crystal-generated SQL, but I'm
not sure. For example one SQL statement looks like this:
Code:
SELECT
Customer_Co0.`Contact ID`, Customer_Co0.`Person First Name`, <...snip>
FROM
(((((`Customer` Customer_Co0 INNER JOIN `Homeelev` Home_Elevat2 ON
Customer_Co0.`Community ID` = Home_Elevat2.`Community ID`)
INNER JOIN `Lotglobl` Divisional_3 ON
Customer_Co0.`Community ID` = Divisional_3.`Community ID`)
INNER JOIN `Dsew14` dsew14 ON
Customer_Co0.`Contact ID` = dsew14.`Contact ID`)
INNER JOIN `Changeor` Change_Orde5 ON
Customer_Co0.`Contact ID` = Change_Orde5.`Contact ID`)
INNER JOIN `comminfo` Community_P1 ON
Customer_Co0.`Community ID` = Community_P1.`Community ID`)
INNER JOIN `CHORAPPR` Change_Orde6 ON
Change_Orde5.`Contact ID` = Change_Orde6.`Contact ID`
WHERE
Customer_Contacts.`Contact ID` = ''
ORDER BY
Change_Orders.`Change Order ID` ASC
When I change the WHERE clause to be Customer_Co0, I get the same error
excpet it is "Expected 1" instead of 2.
I am getting desperate to get a fix for this, so any advice you can pass my
way would be appreciated.
Thanks!
Josh