db.ExecuteSQL( SqlString )
in [MFC]
|
From: magix on 18 May 2008 14:47 This is about Visual C++ doing insertion into MS Access Database. SqlString = "INSERT INTO ...."; db.ExecuteSQL( SqlString ); How can I organize my variable arguments into Sql String, so that it can be executed ? SqlString = ("INSERT INTO myTable (vName, iMemberID, vMemberType,dExpiryDate, iPax, dCreateDate) VALUES(%s,%s,%s,%s,%d,%s)",szBufName, szBufID, szBufType, szBufDate, szBufPAX, getDate( )); is not right, what could be the right way to having variable arguments ? Many thanks. Regards, Magix
From: magix on 18 May 2008 16:36 issue resolved. Please ignore this. "magix" <magix(a)asia.com> wrote in message news:483079c8$1_2(a)news.tm.net.my... > This is about Visual C++ doing insertion into MS Access Database. > > SqlString = "INSERT INTO ...."; > db.ExecuteSQL( SqlString ); > > > How can I organize my variable arguments into Sql String, so that it can > be executed ? > > SqlString = ("INSERT INTO myTable (vName, iMemberID, > vMemberType,dExpiryDate, iPax, dCreateDate) > VALUES(%s,%s,%s,%s,%d,%s)",szBufName, szBufID, szBufType, szBufDate, > szBufPAX, getDate( )); > > is not right, what could be the right way to having variable arguments ? > > Many thanks. > > Regards, > Magix >
|
Pages: 1 Prev: capture magnetic stripe input invisibly Next: GetRecordCount |