I used this funtcion a do not display error but dont update my database in sql server. When i excute de program i do the following:

SELECT CATEGORIAS
replace descr WITH thisform.ntext1.Value

eselect=[select * from VFPSQLPRACT3 where CAT=']+thisform.numsecu+[']

thisform.conectar()
thisform.categorias=thisform.crearsql(eselect)
thisform.categorias=dbf2rs('categorias')


lseguir=thisform.actualizar(thisform.categorias,.t.,.t.)


a=thisform.categorias.fields('descr').value

if lseguir=0
return 0
ENDIF

thisform.desconectar()
thisform.Refresh

in the example above CATEGORIAS is a VFP cursor that i update raplacing one row by text follow it, thisform.conectar is a method that makes the conection to sql serve, thisform.categorias is a property of my form, dbf2rs is the function that i am using to convert cursor to recordset,thisform.actualizar is a method for update the rs using updatebacth. When i do that a can see what are in the recorset using a=thisform.categorias.fields('descr').value but my table in SQL server 2000 dont update.

what i can do, the function convert from cursor to recordset but dont update.