Error when SQL statement includes a key word
Posted: Mon Sep 22, 2008 5:42 pm
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
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