Hi
I have one temporary table ( TmpLinEnc ), with fields :
RefArtigo
QTD
i have table ( LinEnc ) , with fields
RefArtigo
QTD
Now , i want update table LinEnc , with TmpLinEnc
Exemple TmpLinEnc
RefArtigo -> Artigox
QTD -> 6
table LinEnc
RefArtigo -> Artigox
QTD -> 10
I want in table LinEnc
RefArtigo -> Artigo1
QTD -> 4 && ( 10 table LinEnc - 6 table TmpLinEnc = 4 )
I know make this with DO WHILE .NOT. Eof() ,
but i like Know make that with one UPDATE SQL
Do You undsertand , and can help me ?
Thanks
Pedro Silva
world is wonderful with your help .