HOW TO USE STR VARIABLES IN SQL WHERE EXPRESSION, DAX 2009

I think most of us faced this issue , when we try to use str variable in X++ SQL statement like below

"Error: Container and unbounded string (text) fields are not allowed in a WHERE expression."


 
Because when trying to use unbounded string variable within a select / where expression , it is expecting a limited sized string , so the solution is to limit the size of variable as below
 






Eventhough we are using string EDT's we won't get this error , because each string EDT will have its size.

No comments:

Post a Comment

Note: Only a member of this blog may post a comment.