SQL Server - UniQuery error when table name contains "&" character

[stevel]

When SQL Server table name contains "&" character, and setting the SELECT statement for TUniQuery (using SQL.Text := 'SELECT * FROM ..... ', then when UniQuery.Open is called, the runtime error is raised:

"Invalid object name "

Sample of the SQL.Text contents:

SELECT * FROM dbo.[Schir&Co.KG$Prod Order];

However if the SQL.Text property is set at design time, it works fine.

Please fix this urgently or release a source patch.

[FredS]

That is part of Unified SQL Macros: http://www.devart.com/unidac/docs/#unisql.htm

There was a post on this.. with solution:
http://forums.devart.com/viewtopic.php? ... 26#p101225

[stevel]

That is part of Unified SQL Macros: http://www.devart.com/unidac/docs/#unisql.htm

There was a post on this.. with solution:
http://forums.devart.com/viewtopic.php? ... 26#p101225

Unfortunately, the solution (setting that global variable to False) does not work for me. The issue persists.

[azyk]

Thank you for the information. We have reproduced the problem and will investigate it. We will notify you about the results as any are available.

[stevel]

2 weeks have passed since your acknowledgement of the issue. Can you please provide an indication of how soon the issue will be fixed?

Instead of waiting until the release of the next version, would it be possible for you to provide a source patch that resolves the issue?

Thanks in advance!

[azyk]

The investigation is still in progress. This issue will be fixed in the next UniDAC build.

[stevel]

When can we expect the next update please? This is urgent and my project is stalled because of this bug.

[stevel]

Please give an indication of when the next update will be released and whether this bug will be fixed in that update.

I need to know because if it won't be fixed in the update, I need to make alternative plans (eg dbGO or FireDAC)...

[azyk]

We have fixed this problem. This fix will be included in the next UniDAC build. If you want to get this fix before the release of the next UniDAC build, send your email address and license number to andreyz*devart*com - and we will send you a night build.