may be this can resolve your problem
if you have not buffering your rute table do this
UPDATE route SET route.lien1= l1, reoute.site1 = m1, route.conn1 = mconn1 where Upper(alltrim(route.route)) =Upper(alltrim(nroute))
or see the SET ANSI help in VFP.

if you have buffering in your route talbe
after the update command, do this:
sele route
=Tableupdate(.t.,.t.)

be sure the cursorsteprop(bufering,5,"route") is ok

sory for my English