I will try that. Thanks Carsten
--- In [email protected], "Carsten F. Frandsen" <[EMAIL PROTECTED]> wrote: > > Hi, > > The best way to do it would be creating an index on Account field. > Next loop thru the and use the update_recordset to bulk update each > accountnumber. > > Best regards > Carsten F. Frandsen > > --- In [email protected], "Jim Dimarzio" > <jpadim2000@> wrote: > > > > Hello, > > Can anyone tell me which way is the most efficient and quicker > > method to replace a field in an AX table with information from a > > text file: Is it quicker to have an outer while select loop run > > through each row (1million rows) then run through 100 lines in a > > text file in a while container loop? Or the other way around? It is > > taking hours to run this the way I have it here. Here is a snippet > > of code that does this, the objective is the text file has 100 rows > > of 'old GL account' "," 'new GL account' Any help is greatly > > appreciated! : > > > > while select forupdate ProjTransPosting (From AX Table) > > { > > inFile = new TextIO(s_path,"r"); > > inFile.inRecordDelimiter('\n'); > > inFile.inFieldDelimiter(','); > > con = inFile.read(); > > aFound = false; > > > > while (con && aFound == false) (READ from Text file) > > { > > oldCOA = conpeek(con,1); > > newCOA = conpeek(con,2); > > if (ProjTransPosting.Account == oldCOA) > > { > > ProjTransPosting.Account = newCOA; > > ProjTransPosting.update(); > > aFound = true; > > } > > else > > con = inFile.read(); > > } > > } > > >
