From Axaptapedia
Here is a piece of code to execute a stored procedure thru Axapta /* GeSHi (c) Nigel McNie 2004 (http://qbnz.com/highlighter) */ .code .imp {font-weight: bold; color: red;} .code .kw1 {color: #0000ff;} .code .co1 {color: #007F00;} .code .coMULTI {color: #007F00;} .code .es0 {color: #666666; font-weight: bold;} .code .br1 {color: #0000ff;} .code .br2 {color: #0000ff;} .code .st0 {color: #FF0000;} .code .nu0 {color: #000000;} .code .me1 {color: #000000;} .code .me2 {color: #000000;}
static void storedProcedure(Args _args) { LogInProperty Lp = new LogInProperty(); OdbcConnection myConnection; Statement myStatement; ResultSet myResult; ; LP.setServer("SeverName"); LP.setDatabase("DataBaseName"); Lp.setUsername("sa"); Lp.setPassword("sa"); try { myConnection = new OdbcConnection(LP); } catch { info("Check username/password."); return; } myStatement = myConnection.createStatement(); myResult = myStatement.executeQuery('EXEC [inventtablesp]');//stored procedure name while (myResult.next()) { print myResult.getString(1); } pause; }REGARDS SREENATH REDDY
