Thanks for reply
I understand the way of delete a record using the sql statement
I have created a recordset and if i want to add a record i use
rs.addnew
rs.fields('xxx').value = "xx'
rs.update
If i want to delete a record i want to use
rs.delete( 1)
rs.update
this one is not working
Kind regards
Jan Dorresteijn
>If oConn is your connection object then
>
>lcSQL = "delete mytable where mykey = " + STR(myvalue)
>lnResult = oConn.Execute(lcSQL)
>
>should do it. However, as you know, this only marks the record for deletion. I seem to recall a thread about issuing a PACK via ODBC. You might want to search for it.
>
>HTH
>
>>How to delete a vfp record with ADO
>>
>>Kind regards
>>
>>
>>Jan Dorresteijn
Précédent
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