Devart Forums

Hi!
Macros is good thing, but you can't remember about & (Bitwise AND).
My valid T-SQL query (SELECT PERMISSIONS(OBJECT_ID('Users'))&26; )
now not valid in SDAC. Because it converted to: SELECT PERMISSIONS(OBJECT_ID('Users'));

It can be solved using whitespaces: SELECT PERMISSIONS(OBJECT_ID('Users')) & 26;
but I think it's not right behavior.

Thank you.

Hi alec,

checkout variable MacroChar (Unit DBAccess).

Hth
Tino

Thank you for information, we have reproduced the problem and fixed it.
This fix will be available in the next SDAC build.
As a temporary solution you can insert space between '&' symbol and number.
In other words, you can write
SELECT PERMISSIONS(OBJECT_ID('Users')) & 26
instead of
SELECT PERMISSIONS(OBJECT_ID('Users'))&26