Im trying to insert value entered in textbox in to one column of ms access databse table using SQL .
Below is my code :
// Open the database
database.Open(NULL,false,false,sDsn);
// Allocate the recordset
CRecordset recset( &database );
x= m_CatID;
// insert data
recset.m_pDatabase->BeginTrans();
recset.m_pDatabase->ExecuteSQL(L"INSERT INTO Categories (CatID,Category) VALUES(?,'jhgjh)",x);
But in the above im getting error as too many arguments in function call.