Skip to Content
0
Jun 03, 2022 at 01:38 AM

Not able to query tables with special characters in table name for MySQL-C# (.Net FW)

147 Views Last edit Jun 06, 2022 at 05:24 PM 2 rev

Hello, we develop a custom viewer for a Crystal Report file using mysql as database. We have multiple tables with fields names with special characters. When we design the report using the Crystal Reports Editor, we apply the article

https://userapps.support.sap.com/sap/support/knowledge/en/2631163

and the report works perflecty.

But when we try to use the same report inside our custom viewer developed in C#, it returns an error :

check the manual that corresponds to your MariaDB server version for the right syntax to use near '% AEL_MP....'

the error is because Crystal Reports libraries are not using the string value DoubleQuotation defined in the they:

HKEY_CURRENT_USER\SOFTWARE\SAP BusinessObjects\Suite XI 4.0\Crystal Reports\Database\QueryBuilder\NameBuilder

Where we can configure o enable the DoubleQuotation for a C# (.Net FW). application because it is not working for a custom application with mysql database?