Active Query Builder support area

Support odbc escape syntax

Avatar
  • updated
  • Completed
I'm surprised that this doesn't already work, but it appears that ODBC escape syntax e.g.:

Select
{fn conat(contactname,companyname)}
From
Customers

...isn't supported in the syntax providers that I have tried (Microsoft Access or Ansi 2003). Is there some other property that needs to be set to make this work, or is this simply not supported?
Avatar
Andrey Zavyalov, PM
Hi,

The current version of Active Query Builder doesn't support ODBC escape syntax. It is possible to implement it in the future versions. For which syntax providers you need to have it the most?
Avatar
Andrey Zavyalov, PM
We will add support of this syntax in the next minor version.
Avatar
Andrew Clark
That would be fantastic if that support was added. I guess it might make sense to have a new, different ODBC syntax provider, or if you use an existing syntax provider the Ansi 2003 syntax provider (TacSQL2003SyntaxProvider) would make the most sense, thank you again!
Avatar
Andrey Zavyalov, PM

The new version provides support for ODBC escape sequences in all syntax providers.