Hi all! New here and already in a jam!
I am writing a small app that show already made report (CR) and i am sending it SQl statement to personalize the results. Now it is all working fine except when I enter a specific collum name in the Query. It's my primary key and is oddly named "SerialNumber+".
Now it's this + that's giving me a headache. whenever I insert it in my Sql statement (in a order by clause) I get the follwing message(from Crystal Report): "ODBC error
river]Unexpected extra token: +".
Note that the report work fine with the same parameters in Crystal report 8.5
Is there any way to pass this so the odbc driver will recognize it?
Here's the full query: SELECT * FROM ConfigurationItem Where.....ORDER BY ItemFR, MakeEn, ModelEN, SerialNumber+
I am writing a small app that show already made report (CR) and i am sending it SQl statement to personalize the results. Now it is all working fine except when I enter a specific collum name in the Query. It's my primary key and is oddly named "SerialNumber+".
Now it's this + that's giving me a headache. whenever I insert it in my Sql statement (in a order by clause) I get the follwing message(from Crystal Report): "ODBC error
river]Unexpected extra token: +".Note that the report work fine with the same parameters in Crystal report 8.5
Is there any way to pass this so the odbc driver will recognize it?
Here's the full query: SELECT * FROM ConfigurationItem Where.....ORDER BY ItemFR, MakeEn, ModelEN, SerialNumber+