Hi all,

Im using SQL CE 2.0, created the database and table succesasfully. I tried to insert the records using SetCommandText and Execute Commands

pICmdText->SetCommandText(DBGUID_SQL, (LPWSTR)(L"INSERT INTO Employees VALUES (10, 'Bose')"));
pICmdText->Execute(NULL, IID_NULL, NULL, NULL, NULL);

This works fine then i tried some dynamic method

pICmdText->SetCommandText(DBGUID_SQL, (LPWSTR)(insertionquery));
pICmdText->Execute(NULL, IID_NULL, NULL, NULL, NULL);
where i framed the insertionquery dynamically like "INSERT INTO Employees VALUES (11, 'Hussain')" and inserted but the function fails

how could i achieve this kindly help me in this regard

Thanks in Advance,

Bose.