Versions des environnements
Network:
Windows 2003 Server
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.
Précédent
Suivant
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement