I'm use VC++ with MFC's and this sentence build errors in the syntax.

Is this SQL sentence wrong...?

CString thecard = "342345";
long  theamount = 330;
CString theDate = "980606";

CString strc = "insert into account(card,amount,date)
values(thecard,theanount,thedate);

pdb->ExecuteSQL(strc);

Very Thanks!!!!!!
josep

You need to put single quotes around char and date datatypes.
CString thecard = "'342345'";
long  theamount = 330;
CString theDate = "'980606'";

Harish

Hi Josep,

Actually what you need to do is something like this:

CString theCard = "342345";
long  theAmount = 330;
CString theDate = "980606";
CString strSql;

strSql.Format( _T("INSERT INTO Account (card,amount,date) VALUES
('%s',%d,'%s');"), theCard, theAmount, theDate );

pdb->ExecuteSQL( strSql );

HTH
--
===================
Frank Hickman
Computers Plus

===================