I always get an exception calling the ExecuteStmt(sStmnt) member of the
class AxaptaRecord if one of the (string) values has the character % included.
Example could be trying to read from ProjGroup table in AX.
public AxaptaRecord tProjGroup = Erp.CreateAxaptaRecord("ProjGroup");
if sStmt string passed to ExecuteStmt is :
“Select %1 where %1.ProjGroupId == ‘SA%5PA’ "
Or
“Select %1 where %1.ProjGroupId == \â€SA%5PA\â€"
An error is return saying “The supplied method arguments are not valid.â€
But if the sStmt is:
“Select %1 where %1.ProjGroupId == ‘SA5PA’ "
Then we get the data ok.
How is string/String wrapping handled ?
|