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