Passing string to SetCommandText

• Lillian Bose

  SSC Veteran

  Points: 257

  More actions

  March 29, 2007 at 8:34 am

  #69718

  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.

• k.subodh1

  Old Hand

  Points: 326

  More actions

  May 28, 2008 at 3:52 am

  #821050

  Hi

  I am developing windows mobile 6 application in vc++ using sql ce database. I have created database file with ext .sdf.I have created table and inserted data in it using Execut function.

  I am developing it on desktop using emulator. I am not getting my .sdf file on disk after creating database. can you tell me where it is storing

  hope u will reply

  thanx