🚀 go-pugleaf

Hi

I'm trying to insert and update information in an Access2000 table using
TADOQuery, and i can't get it
to work, Selecting works 100%.

the code i'm using is....

TADOConnection *ADOConnection = new TADOConnection(NULL);
TADOQuery *ADOQuery = new TADOQuery(NULL);

ADOConnection->Connected=false;
ADOConnection->ConnectionString=<connection_string_variable_here>;
ADOConnection->LoginPrompt=false;
ADOConnection->Connected=false;

ADOQuery->Close();
ADOQuery->Connection=ADOConnection;

ADOConnection->BeginTrans();
try {
  ADOQuery->SQL->Clear();
  ADOQuery->SQL->Add("MY INSERT STATEMENT HERE");
  ADOQuery->Prepared=true;
  ADOQuery->ExecSQL();
  ADOConnection->CommitTrans();
} catch(...) {
  ADOConnection->RollbackTrans();
}
ADOQuery->Close();
ADOConnection->Connected=false;

delete ADOQuery;
delete ADOConnection;

if i copy the exact sql statement and run it in mssaccess2000, it executes
properly,
but not within my application.

ADOConnection is connecting properly, it juist appears that the ADOQuery
keeps rolling back
the transaction.

any idea as to why this is happening?