static server ResultSet executeSqlWithResult(str _sql)
{
Connection sqlConnection;
Statement sqlStatement;
ResultSet sqlResultSet;
SqlStatementExecutePermission perm;
;
sqlConnection = new Connection();
sqlStatement = sqlConnection.createStatement();
perm = new SqlStatementExecutePermission(_sql);
perm.assert();
sqlResultSet = sqlStatement.executeQuery(_sql);
CodeAccessPermission::revertAssert();
return sqlResultSet;
}
static server int executeSqlStatement(str _sql)
{
Connection sqlConnection;
Statement sqlStatement;
SqlStatementExecutePermission perm;
str sql;
int result;
;
sqlConnection = new Connection();
sqlStatement = sqlConnection.createStatement();
perm = new SqlStatementExecutePermission(_sql);
perm.assert();
result = sqlStatement.executeUpdate(_sql);
CodeAccessPermission::revertAssert();
return result;
Below Code to get customer Primary Address in Ax 2012. CustTable custTable_P; DirPartyTable dirPartyTable_P; DirPartyLocation dirPartyLocation_P; DirPartyLocationRole dirPartyLocationRole_P; LogisticsLocation logisticsLocation_P; LogisticsLocationRole logisticsLocationRole_P; LogisticsPostalAddress logisticsPostalAddress_P; LogisticsPostalAddress primaryAddress_P; while select custTable_P where custTable_P.AccountNum =='ED_01029' join dirPartyTable_P where dirPartyTable_P.RecId == custTable_P.Party join dirPartyLocation_P where dirPartyLocation_P.Party == custTable_P.Party && dirPartyLocation_P.IsPrimary==NoYes::Yes join dirPartyLocationRole_P where dirPartyLocationRole_P.PartyLocation == dirPartyLocation_P.RecId join logisticsLocationRole_P where logisticsLocationRole_P.RecId == dirPartyLocationRole...