Merci Diane,
C'a marché!!...It worked!!
>Bonjour Perry,
>
>Try this:
>
>private lcDescript, lcCondition
>lcDescript = "Finished Goods #" + alltrim(STR(i))
>lcCondition = test1.code1
>
>sql_sta = 'update code2 set descrip = ?lcDescript ' + ;
> 'where code1 = ?lcCondition'
>
>chs=sqlexec(ch,sql_sta)
>
>Good luck,
Perry E. Chrzanowski
Programmer/Analyst
Saturn (Solutions) Inc.