Native Error 156 with Sybase

rbuser

I designed a report for a client which uses the COUNT(*) function on a
Sybase database.

When the report is run, it fails with 'Native Error 156 - incorrect
syntax near the word COUNT.'

The alias assigned by RB for the COUNT(*) field is COUNT.

In the list of SQL reserved words in daSQLReservedWords.pas, 'count' is
NOT in the list of reserved words for the database type dtSYBASEASA.

When I explicitly set my database type to dtMSSQLServer, deleted the
COUNT(*) field and added it back, the alias assigned was 'COUNT_2'.

I have yet to try the modified report at the client site but I thought
I'd report this anyway.

Thanks,
Arthur

nicocizik

Hi Arthur,

Thanks for pointing this out. There is a patch available for RB 10.06 that
adds the "count" string to the reserved words of a Sybase ASA DB and it will
be added to the next release of ReportBuilder. If you would like the patch,
send a short email to support@digital-metaphors.com and we'll get it to you
asap.

--
Regards,

Nico Cizik
Digital Metaphors
http://www.digital-metaphors.com