Error message: Failed to open a table - there were no specified columns to retrieve.

Rs. The Open (CRecordset: : the snapshot, SQL, CRecordset: : readOnly);

Most of the queries are no problem,

But have DECLARE, the SET, IF LEFT this query will put below the error

Baidu, Google for a long time didn't also similar problems, the parameters of the Open also changed tried, or an error

Do you do?

CodePudding user response:

You DELETE need to write the database, such as
CRecordset: : readOnly can only read here

CodePudding user response:

reference 1st floor oyljerry response:

you need to write the database such as DELETE
CRecordset: : readOnly here can only read

What to what? I tried several all not line...