ADO - Insufficient Base Table Info...

[scuzymoto]

Im attempting to delete a record in a database that Im connected to using the adodc control. I built the connection string with the wizard and gave myself read/write permissions.
Then useing the code Recordset.Delete or just hitting the delete key with the record highlighted on the data grid gives me the error... "Insuficient Base Table Information For Updating Or Deleting." What other information do I need to supply it? Can anyone help?? Thanks.

[Danny Layne]

It is hard to answer your question without seeing the SQL you are using to build your recordset, but here are some ideas:

Check your SQL soes not terminate with the semicolon character - ADO does not like this at all.

Are you using DISTINCT?

Are you using the correct RecordsetType - not adopenstatic?

is your recordset based on a view, or a subquery?

One of these should provide you with the answer!

[scuzymoto]

I would have never thought of removing the ';'. Thanks, that fixed it. Ill have to remember no semicolon on the ado querytext.