Zeoslib Portal

Hello jeremicm,

I guess you are not using unicode components. Please try TNT components or similar (or have delphi XE + that supports unicode out of the box).

Good luck!

Hello, mdaems,

i wanted to ask if You had considered changing SVN to Git? SourceForge supports that SCM system too. It would be a good time to make that transition if You think of moving the repository.

There's some info on distributed SCM systems:
http://www.infoq.com/articles/dvcs-guide

the real reason I'm not doing so is this wouldn't be workmanlike anyway

Respect.

Will wait for your fix.

Good Luck!

hm...
there is not much I can think of then... If you send me your program source to private I will try to investigate the source this weekend.

Or maybe someone with experience of zeos + mssql will appear hier.

hello,

is procedure TGPRSConn.FTPLoadCommands; executed from other than main thread ?

PetyaMaster , cos when all threads were started at the same time, connection problems occurred This is strange. I think you should try to investigate why such things happen. It is very hard to find what is wrong when the program crashes once a week. If several connection objects in separate threads...

So you say that Zeos 6.x.x is completely incompatible with multithreading, but 7.x is ? You say this function is implemented in versions 7.x above ? Am I understanding it right ? No, what I ment it has problems after connection loss (in the Postgresql part at least). This does not mean you can't us...

Hello, PetyaMaster , when programming multithread application you must remember not to use TZConnection components from several threads. All connection and using it components should be used in single thread. I see you are using mysql. I have no experience with it, but I have some using postgresql. ...

hello gmb , You are right - AutoCommit generates transaction for every statement, so transaction control is not possible. You should turn it off. You can add SQL monitor component to see what is being done. Setting isolation level to "Read committed" ensures that the changes made in this t...

Hello iru,

no problem. I'm glad to help.

By the way, You don't need "LocalQuery.ApplyUpdates;" unless you are using CachedUpdates

Good luck!

Ian, see the attachment. I've made an examble of using tzupdatesql component. The query points to ZUpdateSQL via UpdateObject property. I used simple queries for the example just to show the point. From what you wrote I would bave tables competition, race, competitor. Only competitor is edited by us...

Hello, iru,

you mean that on post the deleteSQL is invoked? Are you sure you don't have the same sql (HeatSQL) in updateSQL?

I use TZUpdateSQL component very often and *never* observed such a behavior.

using Zeos7 on windows machine. DBMS = PostgreSQL

Hello gmb,

have you turned AutoCommit off and set TransactIsolationLevel to ilNone ?

In my projects I use the same approach (managing transactions manually). The difference is I use 'START TRANSACTION ISOLATION LEVEL READ COMMITTED;' to start the transaction.

Good luck!

Hello, IbeDBob , If you have a simple query like 'select id, name from person' in a tzquery then the component is capable of performing inserts, updates and deletes. The problem occurs then the query gets complex (using several tables). In that case you would not be able to use methods like Insert, ...

hello noctrex , I don't know how it is with ms sql, but with postgresql I use text datatype in DB for fields that are more than 255 char long. That way I get memofield instead of stringfield and it may contain more than 255 chars. Maybe someone here with experience using ms sql will add some new ide...