getting syntex error for progress database
Posted: Tue Sep 02, 2008 7:42 am
Hi
While using function like trim,substr in the sql for progress database it is working fine.But while using the same query in the ODBC stage and run it is giving syntex error.Any idea why?
Select substr(company_name,1,5) from company works fine in the progress database.
But the same query giving error in ODBC stage.
Thanks in advance.
While using function like trim,substr in the sql for progress database it is working fine.But while using the same query in the ODBC stage and run it is giving syntex error.Any idea why?
Select substr(company_name,1,5) from company works fine in the progress database.
But the same query giving error in ODBC stage.
Thanks in advance.