Did you consider using CursorAdapter? It'll do all the conversions for you.

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