Search found 5 matches

by danielf
18.12.2009, 18:30
Forum: 6.6 - stable
Topic: Begin and commit not working with postgresql
Replies: 5
Views: 783

Unfortunately i have uninstall 6.6.5 components and installed the old ones, i know i had tried both ways autocommit true and false, because i dont want zeos to automatically start any transaction. In automatic mode, (i really cant remember if it was this property but i believe so) it worked until so...
by danielf
18.12.2009, 11:54
Forum: 6.6 - stable
Topic: execSQL with POSTGRESQL
Replies: 4
Views: 712

Thank you for your reply's >I think you using the wrong command, >ZQuery1->Close(); >ZQuery1->SQL->Text = "INSERT INTO cars(model) VALUES('A3');"; >ZQuery1->Open(); <-- sohuld be ZQuery1->ExecSQL( ); i know that's why i post this. >... I can tell that you need to close, >clear, assign new ...
by danielf
18.12.2009, 11:41
Forum: 6.6 - stable
Topic: Begin and commit not working with postgresql
Replies: 5
Views: 783

Sorry for the missing information,

AutoCommit = true
TransactIsolationLevel = ReadCommit
database is PostgresSQL

Thx Wild_Pointer for ur reply
by danielf
16.12.2009, 11:43
Forum: 6.6 - stable
Topic: Begin and commit not working with postgresql
Replies: 5
Views: 783

Begin and commit not working with postgresql

Hi,
iam using ZSQLMonitor, when i execute the methods, StartTransaction, commit or rollback none of this commands are being sent to the database

begin;
commit;
rollback;

Anyone can help?

Thx in advanced
by danielf
15.12.2009, 18:45
Forum: 6.6 - stable
Topic: execSQL with POSTGRESQL
Replies: 4
Views: 712

execSQL with POSTGRESQL

Hi all, i have been using zeos version 6.1.5 for quite some time, i have been having trouble trying to migrate one of my old applications to use the new version of zeos 6.6.5. One of the problems, is that i cant do a simple insert in the following way. Iam using c++builder 6, with postgresql 8.2.13,...