>Can you delete a SQL Server record with the recordset Delete?
>I am using VFP6 and ADO 2.1 and SQL 7 with SP1.
>When I try the RecordSet.Delete(1)
>I get an error message "OLE IDispatch exception code 0 from ADODB.Recordset: The operation requested by the application is not supported by the provider..."
Try the ODBC provider MSDASQL. Or a regular ODBC DSN as your connection string. I've gotten the same error messages when using the native SQL provider. Now what is the (1) for? I don't see any reference on ADO where the Delete method would accept any parameters.
Previous
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only