>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.