Syntax Error when creating a report

Mike_Cutts · Post by **Mike_Cutts** » Fri Jul 04, 2003 7:57 am

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.

kfleming · Post by **kfleming** » Fri Jul 04, 2003 9:07 am

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

Mike_Cutts · Post by **Mike_Cutts** » Mon Jul 07, 2003 4:19 am

Could you let me know roughly when a fix may be available for the above issue, so we can let our clients know.____Thanks.

kfleming · Post by **kfleming** » Mon Jul 07, 2003 7:34 am

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

Liveware Publishing Support Forum

Syntax Error when creating a report

Syntax Error when creating a report

=> Syntax Error when creating a report

==> Syntax Error when creating a report

===> Syntax Error when creating a report