Crystal Reports 11, using command with parameter, MySQL

[kray4660]

I am attempting to use a parameter in a command in CR 11 with MySQL (I believe the version is 5.1) as a data source. Unfortunately I am getting various syntax errors. I have tried putting the parameter in single quotes ('{?Start Date}'), no quotes, and single quotes and percent sign ('%{?Start Date}%').

 

[pmax9999]

I have not used MySQL, but the only thing I can think of is to check that the data types for the Parameter and the database column actually match.

I am sure you would have checked, but I know from personal experience that sometimes the obvious things are overlooked.

Cheers
Pete

 

[kray4660]

Now that you mention it, I was doing some testing with the CurDate() function and could not get everything to work correctly until I converted my datetime to a date. I will check it out and let you know. FYI: The ODBC I am using is a third party vendor that uses the MySQL as a database, but not all the functions available for MySQL are available through this ODBC.

 

[kray4660]

Unfortunately I did a cast (to date) for my field and to the parameter and I got the same error (OpenAccess SDK SQL Engine error). I am going to see if I can find an explanation of the error message.