problems with transactions in C++Builder
От | igor |
---|---|
Тема | problems with transactions in C++Builder |
Дата | |
Msg-id | 19111011504.20000628104747@mailru.com обсуждение исходный текст |
Список | pgsql-general |
Greatings! Help me please to resolve my problem. As appeared, postgesql server doesn't rollback transaction in 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 по дате отправления: