problems with transactions in C++Builder

Поиск
Список
Период
Сортировка
От igor
Тема problems with transactions in C++Builder
Дата
Msg-id 1341165475.20000629072301@mailru.com
обсуждение исходный текст
Список pgsql-general
Greatings!

Help me please to resolve my problem.
As appeared, postgesql server doesn't rollback transaction,
when I use
C++ Builder environment. May be sombody have
an idea, how to make it work?
The test source in the bottom of the letter.

I will be very greatefull  for any help.

Igor.

======================================
  CD->srvdb->StartTransaction();
  CD->EQuery->Close();
  CD->EQuery->SQL->Clear();
  sprintf (str, "begin");
  CD->EQuery->SQL->Add(str);
  CD->EQuery->ExecSQL();

  CD->EQuery->Close();
  CD->EQuery->SQL->Clear();
  sprintf (str, "lock mytable");
  CD->EQuery->SQL->Add(str);
  CD->EQuery->ExecSQL();

   sprintf (str,"update mytable set \
   active=1 where st = '2020201'" );

 CD->EQuery->Close();
 CD->EQuery->SQL->Clear();
 CD->EQuery->SQL->Add(str);
 CD->EQuery->ExecSQL();


  CD->EQuery->SQL->Clear();
  sprintf (str, "abort");
  CD->EQuery->SQL->Add(str);
  CD->EQuery->ExecSQL();
  CD->srvdb->Rollback();

==============================

the field "active" save new value = 1 after
'abort' command.



В списке pgsql-general по дате отправления:

Предыдущее
От: igor
Дата:
Сообщение: test
Следующее
От: "John Huttley"
Дата:
Сообщение: Re: Limit for an transaction