mardi 8 février 2011

How to use Str Variable in SQL Where Expression, in DAX

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

static void StrCompiler(Args _args)
{
    str 20                  ItemId;
    InventTable             inventTable;
    ;
   
    select inventTable
    where inventTable.ItemId == ItemId;

}

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

Happy Daxing!

Aucun commentaire:

Enregistrer un commentaire