Previous Thread

8/15/2006 5:08:01 AM    How to pass strings that include character % to .net business conn
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 ?