hariprasadp: Code for pulling data from other than AX Database of SQL to AX Table

[Blog bot]

Источник: http://hariprasadp.spaces.live.com/B...B91F!203.entry
==============

//HariPattela- code for pulling data from other than AX Database of SQL to AX Table
static void SQL_CustPaym(Args _args)
{
 LoginProperty LP = new LoginProperty();
  myConnection;
  myStatement;
  myStatement1;
  myResult,myResult1;
  paymTerm;
 str tstCustId;
 ;
 //DSN - if the data base is on diffrent server
 LP.setDSN("SqlTestSvr");
 LP.setDatabase('newErp');
 myConnection = new OdbcConnection(LP);
 myStatement = myConnection.createStatement();
 myResult = myStatement.executeQuery("SELECT * FROM SA_PayTerm");
 while (myResult.next())
 {
  = myResult.getString(1);
 if(!paymterm::find(tstCustId))
 {
 ttsbegin;
 paymTerm. = tstCustId;
 paymTerm. = myResult.getString(2);
 paymTerm. = any2int(myResult.getString(3));
 paymTerm.insert();
 ttscommit;
 info(tstCustId);
 }

 // myResult1 = myStatement.executeQuery("delete FROM SA_PayTerm "+ "where SA_PayTerm.PaymentCode ="+"'"+ tstCustId+"';");
//               _strSQL = "delete from fwcatns_materialmaster " +
//                  "where MaterialId = '" + _InventTable.ItemId + "';";
//        while(myResult1.next())
//        {
//            info("Payment Term Id = %1", tstCustId);
//        }
//
 }
}

==============
Источник: http://hariprasadp.spaces.live.com/B...B91F!203.entry