What is wrong with these SQL statements??

[IrishSonic]

Hiya getting a message saying "Database error - There were no columns specified to retrive." when using these 2 lines: SqlString = "DELETE * from Branches WHERE Branch_No LIKE '4%' "; OR SqlString = "INSERT INTO Branches (Branch_No,Branch_Name) VALUES ('6','Derry') "; But Branch_No is the first column and Branch_Name is the second.. Am I using the statements wrong?? Thanks, grahamoj.

[vin]

grahamoj wrote: SqlString = "DELETE * from Branches WHERE Branch_No LIKE '4%' "; It should be DELETE FROM WHERE Vini

[Ted Ferenc]

grahamoj wrote: SqlString = "INSERT INTO Branches (Branch_No,Branch_Name) VALUES ('6','Derry') "; 1. What is the error message 2. Does the row exists, if so the statement will fail 3. Is Branch_No declared as INT it so try 6 not '6', although I don't think this will make any diference.

---

If I have seen further it is by standing on the shoulders of Giants. - Isaac Newton 1676

[IrishSonic]

// Open the database database.Open(NULL,false,false,sDsn); // Allocate the recordset CRecordset recset( &database ); // Build the SQL statement SqlString = "DELETE FROM Branches WHERE Branch_No LIKE '4%'"; //SqlString = "INSERT INTO Branches (Branch_No,Branch_Name) VALUES ('6','Derry') "; // Execute the query recset.Open( CRecordset::forwardOnly,SqlString,CRecordset::readOnly ); I now know it is the last line, so changed it to: recset.Open( AFX_DB_USE_DEFAULT_TYPE,SqlString,CRecordset::none ); but this still does not delete the line. The error message I am getting is: "Database Error: Attempt to open a table failed - there were no columns to retrive were specified". But my table is called Branches and is specified!! Any ideas. grahamoj

[Ted Ferenc]

What I always do is use "Query Analyzer" to check out my SQL statement, I tried the following on a scratch table use teds INSERT INTO winrasdialit (col001, col002, col003) VALUES('hello', getdate(), 5) It works OK, so if your SQL statement works in "Query Analyzer" you have at least eliminated one possible error. It does look like you do not have the database open for read only as delete seems to work? I don't use CRecordset so I can't comment on your synatx

---

If I have seen further it is by standing on the shoulders of Giants. - Isaac Newton 1676

[JockeP]

Hi! I'm just curious how you manage to execute those insert and delete queries? I get rt error when doing it like this: CDaoDatabase* m_pDB; CDaoRecordset* m_pRS; m_pDB = new CDaoDatabase; m_pRS = new CDaoRecordset(m_pDB); try { m_pDB->Open("c:\\accessdb\\db1.mdb"); // CString strQuery = _T("SELECT * FROM Table1"); //Works just fine... CString strQuery = _T("INSERT INTO Table1 VALUES ('3', 'Olga')"); //Doesn't work m_pRS->Open(dbOpenDynaset, strQuery); } catch (CDaoException* e) { AfxMessageBox(e->m_pErrorInfo->m_strDescription); e->Delete(); } Can you tell me how to do it?

[Kelly Herald]

Since the DELETE and INSERT commands don't return a recordset you shouldn't use the CDaoRecordset (or CRecordset) class to execute them. Just use the Execute method in the CDaoDatabase (or CDatabase) class. Kelly Herald Software Developer MPC formerly Micronpc