Page 1 of 1

Edit, Post, Commit

Posted: Tue 19 Oct 2010 10:11
by Blade79
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.

Posted: Tue 19 Oct 2010 12:53
by AlexP
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.

Posted: Tue 19 Oct 2010 13:14
by Blade79
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