arnaldo
16th July 2013, 23:30
I have done a exporting from a various tables to a CSV files on LN FP7.
Now i wanna to import from a CSV files to a existing table on LN FP8, it means that i wanna to update it.
My scripts begins like that :

functions:
function extern create.imp.files()
{
create.imp.cidades()
create.imp.cep()
create.imp.unidades()
create.imp.pais()
create.imp.estados()
}

function create.imp.cidades()
{
long ret
archive.o = creat.tmp.file$( bse.tmp.dir$())
ret = client2server("c:\temp\ln\TCCOM139.TXT", archive.o, false, false)
point.o = seq.open(archive.o, "r")

while not seq.gets(buff.o, 1000, point.o)

endwhile
seq.close(point.o)
}


I pass the data to a variable buff.o and now how am i pass this data to a table ???

mark_h
16th July 2013, 23:59
Well there is not a whole lot of information - I would take the input buffer, split it into database fields and do a find, update or insert. I am not sure exactly what you have to work with.