Zeoslib Portal

carlocat , you haven't noted what DB you are using. I guess that you don't have the order by statement in your query. Because of that when you post the changes, the record goes to the end of your result set. When testing on postgresql I get similar results but the order changes not immediately afte...

Hello haentschman,

Can you provide the table create script and the SQL query you use in TZQuery?

kwanbis,

But, how do i create a simple table, that has 1 text field...

I would recommend using ZConnection.ExecuteDirect('CREATE TABLE FOO( ....'


Good luck!

Hello mdaems , I wanted to ask if there will be separate components like ZIBEventAlerter, ZPGEventAlerter, or the effort should be made to put them into single ZEventAlerter? First option is bad as it destroys the ease of protocol selection in TZConnection as there would be separate components for e...

Hello, mrLion , It's nice to have someone who is willing to enrich the Zeos functionality for Postgresql. I have a question for you - how are you going to listen for event notifies? http://www.postgresql.org/docs/current/interactive/sql-listen.html states that "With the libpq library, the appli...

Hello zippo,

You should check http://zeos.firmos.at/viewtopic.php?t=2627&highlight= . Id does not answer how to create DB for SQLite, but I think you will find the analogy.

Good luck!

emils,

please try something like that:
It works with postgresql, so I guess it will work for firebird too.

testebelo , I think what you need is to set Field1.ReadOnly := false; or do you want the fields to become writable once you attach ZUpdateSQL to the query? haentschman , you wrote, that Query.ReadOnly is false but did you check the ReadOnly property of the fields of your query? What is your query a...

Hello, peterd , This is wild guess, but what date format is used on your computer (locale). It seems that the error is related to different formats on your computer and the DB server. Try changing your locale date time formate to YYYY-MM-DD HH:NN:SS. If that helps, then it is for sure date/time conv...

suarahati,

first of all you should have started a new topic - not post in this as your problem is not related to the "TZConnection concurrency questions" .
There is no such dialog build in Zeos to change database. You should create one yourself.

wahyudi,
please read this post http://zeos.firmos.at/viewtopic.php?t=2643&highlight= . It seems to be the same problem.

Hello, all from http://www.postgresql.org/docs/8.4/static/libpq-threading.html I found out, that: "One thread restriction is that no two threads attempt to manipulate the same PGconn object at the same time. In particular, you cannot issue concurrent commands from different threads through the ...

Gorky,

Please add SQLmonitor to your project to see what queries are being executed. That way you'll find the one responsible for your problem.

hi, guidoaerts,

try SELECT table1.column, table2.column from table1, table2 where table1.id = 1 and table2.id = 2

mdaems , Thank you for providing the link to the bug report. Now I see why the change was introduced. The memory leak appears because on TZPostgreSQLConnection.Open the Connect structure in pqlib is created no matter if connection was successful or not. This is ok as pqlib must pass error message b...