TextReader1.Initialize(File.OpenInput(File.DirApp & "/db/", "ANAG.DAT"))
line = TextReader1.ReadLine
nRiga=nRiga +1
Progress = Progress + 1
ProgressBar1.Progress = Progress / TotalRec
Label_Progress.Text = $"${NumberFormat(ProgressBar1.Progress,0,0)}%"$
Do While line <> Null
Log(nRiga &"|" & line) 'write the line to LogCat
line=line.Trim
cEan=line.SubString2(1,13)
cDescriz=line.SubString2(13,30)
cUnMis = line.SubString2(43,46)
cPzxC=line.SubString2(46,51)
cPrezzo=line.SubString2(13,30)
cRep=line.SubString2(13,30)
cCodArt="00001"
cIva="22"
cCosto="0002000"
cEsiste="20"
'////////////////////////////////////////////////////////
Dim m As Map
m.Initialize
m.Put("ean", cEan)
m.Put("codice", cCodArt)
m.Put("DESCRIZ", cDescriz)
m.Put("Um", cUnMis)
m.Put("pzxc", cPzxC)
m.Put("Prezzo", cPrezzo)
m.Put("rep", cRep)
m.Put("Iva", cIva)
m.Put("Costo", cCosto)
m.Put("ESISTE",cEsiste)
m.Put("id",Null)
arc.Add(m)
line = TextReader1.ReadLine
nRiga=nRiga +1
Loop
TextReader1.Close
Log("Inserisco i dati in anagrafica")
Label1.Text="Inserisco i dati nel db"
Log("SCRITTURA IN CORSO....")
DBUtils.InsertOrUpdateMaps(Sql1, "anag", "ean",arc)
CloseDB
'' log
'' SELECT [ean] FROM [anag] WHERE [ean] = '031195000041'
'' value_exists: (Map) Not initialized
. ExecuteMap: SELECT [ean] FROM [anag] WHERE [ean] = '000000855555'
' No records found.'