Edit, Post, Commit

Discussion of open issues, suggestions and bugs regarding PgDAC (PostgreSQL Data Access Components) for Delphi, C++Builder, Lazarus (and FPC)
Post Reply
Blade79
Posts: 2
Joined: Tue 19 Oct 2010 10:05
Contact:

Edit, Post, Commit

Post by Blade79 » Tue 19 Oct 2010 10:11

Hello.
Problem in the following.
I use at work with components the following scheme:

Code: Select all

PgConnection->StartTransaction();
PgQuery->Insert();

//Filling of the data of record

PgQuery->Post();
PgConnection->Commit();
All works. I see in DbMonitor that record is sent on the server, and after command Commit I her see in other application

Further...
I do

Code: Select all

PgConnection->StartTransaction();
PgQuery->Edit();

//I change for example in my case one of fields

PgQuery->Post();
PgConnection->Commit();
And here...
In DbMonitor I see that on the server leaves комманда UPDATE, and in parametres new value leaves also weeding, however, after комманды Commit, the data on the server does not change :(
And I do not see these changes in other application.

It is a bug? Or I on a rake any come? Help, please.

AlexP
Devart Team
Posts: 5530
Joined: Tue 10 Aug 2010 11:35

Post by AlexP » Tue 19 Oct 2010 12:53

Hello,

I can not reproduce the problem.
Please send me the following information:
- exact version of PgDAC;
- exact version of PostgreSQL;
- exact version of IDE;

Also if you can send me a script to create the table and sample project to alexp*devart*com, it would help me to reproduce and solve the problem.

Blade79
Posts: 2
Joined: Tue 19 Oct 2010 10:05
Contact:

Post by Blade79 » Tue 19 Oct 2010 13:14

AlexP wrote:Hello,

I can not reproduce the problem.
Please send me the following information:
- exact version of PgDAC;
- exact version of PostgreSQL;
- exact version of IDE;

Also if you can send me a script to create the table and sample project to alexp*devart*com, it would help me to reproduce and solve the problem.
I have sent you the information from the address [email protected]
I will be glad to receive the answer to this address
In advance thanks

Post Reply