Page 1 of 1

Error when SQL statement includes a key word

Posted: Mon Sep 22, 2008 5:42 pm
by Andre2
Hi There

Im using ver 2008.2.273.0 and am finding an error when the report is combiled if I have a "key" word in an sql statement. eg:

Select Date,Amount,Reason from MyTable where RowID= 25 will fail when the report is combiled but

Select Date as TransDate,Amount,Reason from MyTable where RowID= 25 is fine

Cheers


Error when SQL statement includes a key word

Posted: Tue Sep 23, 2008 7:52 am
by Edward
Hello, Andre.

Please select that DataSource in the Designer, then switch to the Property Editor and set AllowExpressions property in false.

Thank you.