>>Finally got it to work using:
>>

>>   go top
>     private name1, number1
>>   scan
>       name1 = column value
>       number1 = column value
>>      csql="update directory set name1=?name  where number= ?number1"
>>      =sqlexec(nAccessHandle,csql)
>>   endscan
>>

>
>This is something I meant as well except can you try using parameters, e.g. see changes I tried in your code. If this would not work, then your way should be OK.

Both ways work, but your code is a lot more readable (=more betterest)
TUVM !!