Page 1 of 1
Syntax Error when creating a report
Posted: Fri Jul 04, 2003 7:57 am
by Mike_Cutts
I am running R&R Report Writer 10+ SQL Edition, and when I try and select a Master Table, it comes up with the below error:____DB Access: [Sybase][ODBC Driver][Adaptive Server Anywhere] Syntax Error or Access Violation: Syntax Error near ^(End of Line)^____I am connecting to a Sybase 7 Database and trying to base the report on a View, ie. CompanyAddresses_View. It seems to prefix the view name with 2 sets of double quotes. Taking the above example, the master table as it appears in the list would be "owner".""CompanyAddresses_View""____Everything seems to work fine when I base a report on a table, rather than a view.____Any suggestions would be much appreciated.____Thanks,____Mike.
=> Syntax Error when creating a report
Posted: Fri Jul 04, 2003 9:07 am
by kfleming
Another user just reported this same double quote problem against an Oracle table. I think that this is a result of a fix that we made to correct a SQL Server problem. We are currently reviewing this problem.__For the moment, the workaround is to revert to Version 10 (which I can supply to you if you do not have it on hand.)____Kathleen__R&R Support__kfleming@livewarepub.com
==> Syntax Error when creating a report
Posted: Mon Jul 07, 2003 4:19 am
by Mike_Cutts
Could you let me know roughly when a fix may be available for the above issue, so we can let our clients know.____Thanks.
===> Syntax Error when creating a report
Posted: Mon Jul 07, 2003 7:34 am
by kfleming
It will be at least two weeks away since the developer who handles that product area is on holiday in the UK and Ireland.____Kathleen__R&R Support