SIMPLE db example

[JockeP]

Hi! I have tried to find a simple way to manipulate a database (in MS Access or MS SQL Server). However, I've not succeeded. I've tried SELECT statements with CRecordset and it works. But it seems like only SELECT statements work. This is what I've tried: 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(); } So how do you add data to a table, modify tables and so on? Cheers, Joachim

[l a u r e n]

im assuming the 3 in ur insert statement goes into a numeric field in the database table ... if so lose the '' around it ... u only have to quote text fields (and prolly date fields sometimes)

---

"even if my world is weird its my world"
biz stuff   about me

[Anonymous]

No, it's a text field

[l a u r e n]

ok well i use odbc for db stuff but it would seem to me that opening a dynaset on an insert statement wouldnt make sense ... u need to simple execute the statement against the db so prolly look for an .execute type command

---

"even if my world is weird its my world"
biz stuff   about me

[JockeP]

ok thanks, but it need more specific ideas... i'm not that experienced with using vc++ to work with databases

[Michael P Butler]

Do you really need to use DAO. ADO is a lot easier. Check out this link for some good examples. http://www.codeproject.com/database/#ADO[^] Michael Wonder Woman, Wonder Woman. All the world's waiting for you, and the power you possess. In your satin tights, Fighting for your rights And the old Red, White and Blue.

[bryce]

JockeP wrote: ("INSERT INTO Table1 VALUES ('3', 'Olga')"); INSERT INTO Table1 (Field1, Field2) VALUES VALUES ('3', 'Olga')"); where field1 and field2 are obviously part of your table (you didnt tell us the structure of your table) Bryce

[Solomon Wu]

Pls Using: CDaoDatabase::Execute Learning and Working