asked on

UPDATE in ODBC

When using Open() to run a database query with ODBC, it appears that only SELECT can be used in the query string. I tried using UPDATE, and it returned debug assertion error dbcore.cpp line 3282. However, when I call CanUpdate(), it returns true.

I once read that in order to make record changes on your database, you first need to do a SELECT query, set the new values in your program and exchange the data. Is this correct? If so, it seems long-winded. Is there a way that UPDATE can be used instead?

mrjoltcola

Not true. All valid SQL statements are fair game in ODBC.

Please post your code so we can see?

brad2575

Does the ID you are using in the ODBC have permissions to do an update on the database?

If so you should just be able to do an update no problem.

reidy_boy

ASKER

I have attached the cpp and h class files, and the code snippet that contains the update query.

CRecordset PositiveResultSet(theApp.GetDatabase() );
CDBVariant Variant;
TCHAR Message[2000];
 
	if (sAcmeConfig[ACME_STAFF_COLUMN] == "")
		return;
 
	sprintf (Message, "UPDATE LECTDETS SET AcmeMiles='10' WHERE SetId='2008/2009' AND LecturerId='ESN'");
	PositiveResultSet.Open(CRecordset::snapshot, Message);

Open in new window

AcmeCorporation.cpp.txt
AcmeCorporation.h.txt