Visual C++ -> SQL Statement -> Access DB / How to ??

[Guest_imported]

Hi everybody,

I've got a little problem.
I'm writing a program with Visual C++ 6.0 ( with MFC - MDI ) wich should add new Data to an Access database ( ODBC - Snapshot ).
My Problem: I'd like to add and delete data by a SQL statement wich contains variables like CString e.g. for the data. ( The data comes from a Dialog defined in the Doc Class )

Can anybody out there tell me, how to send the SQL command for example from my Doc Class ???

Thanx,
SAM

 

[Valius]

Is it that you are having problems piecing your SQL statement together with the data in the variables so you can execute the statement?

Niky Williams
Lead Engineer
NTS Marketing, Inc.

 

[Guest_imported]

Hi, my problem is to find a VC++ command to send the SQL statement and how to use this command.

Thanks SAM

 

[KeithBrautigam]

You probably want to use either CDatabase::ExecuteSQL or CDaoDatabase::Execute. For info on these functions, try the following two links.

CDatabase:

http://msdn.microsoft.com/library/d...mfc98/html/_mfc_cdatabase.3a3a.executesql.asp

CDaoDatabase:

http://msdn.microsoft.com/library/d...mfc98/html/_mfc_cdaodatabase.3a3a.execute.asp

Also, Microsoft has a few MFC database samples available. To find them, go to

http://msdn.microsoft.com/code/

On the left, select "Code Examples". Then pick "Visual Tools and Languages". Then "Visual C++". Then "Microsoft Foundation Classes". Then just browse the list and try to pick out something that might help.

 

[Guest_imported]

That's what I was looking for !
Thank's a lot and greetings from germany,
SAM