Zeoslib Portal

Hi,

Either you can set QRY.CachedUpdates to false after creating it, or call ApplyUpdates after ExecSQL, that should work. Calling ApplyUpdates for an other TZQuery will only apply the updates of that.

HTH
Rüdiger

Oracle IS supported! Look at TZConnection.Protocol. There you will find oracle and oracle-9i. If you want DB2 support, you will probably have to write it yourself and contribute it to the project...

Well, I only use Zeos in "private" projects, so there are no problems with performance and concurrence, with Firebird, MySQL, a little Oracle, mostly with Kylix. There have been nor real difficulties so far, and if you encounter them, there is this forum.

hth
Rüdiger

Happens to me too: ORA-00932 - BINARY expected - got BLOB (in my case it is BLOB not CLOB), which is strange, it is a BLOB and it should expect a BLOB. ZSQLMonitor didn't show anything suspicious. Maybe it is because the client is 10g and the database 8i. I didn't investigate it further up to now.

Hi, Have you tried to use the Instant Client? This one consists mainly of some dlls. It can be downloaded from technet for free. You will still need a tnsnames.ora (with IP of the server etc.) and an environment variable TNS_ADMIN which points to the directory where tnsnames.ora is located. hth Rüdi...

One of the most common causes is that you didn't set ReadOnly to false in the TQuery properties.

Just being curious: how did you solve it?

For me it helped to do a ZQuery.ApplyUpdates after the ZQuery.Post, although I didn't use cached updates.
With autocommit try it this way: set it to true, then at the right point issue a StartTransaction (which sets it internally to false, strange enough...) and finally a Commit.

hth
Rüdiger

What do you think it should behave? If the SQL hits many rows it will update many rows, it has nothing to do with zeos.
Why is there no primary key? It would make things much easier, and you would not have such a huge where clause.

Hi!

For me it works normally, as in Delphi: doubleclick on the TZQuery, or right-click and then choose Edit Fields.
I use Lazarus 0.9.13 (quite old, I know) and Zeoslib (zeosdbo_rework) from 2006-03-18, I don't remember from where.

Regards,
Rüdiger

Hello! I have to agree with Fabian. The behaviour is strange and not what you would expect. If you would like to do transactions on your own, you would put autocommit=false and then when wanted to start a transaction, and here comes this error. But as now quite everybody knows that it works this way...

You can not change the character set after database creation, only by doing an export > create a new database with the new character set > import. Understandably, as the present character set is "physically there". Still more so, if you want to change from a 1 byte to a 2 byte characterset...

Cariad,

In your tnsnames.ora entry the SERVICE_NAME line looks wrong for me. Either write SID = XE or SERVICE_NAME = XE.mydomain.fr

hth
Rüdiger

We are talking here about "transaction isolation level", and there is no such as read only with Oracle. It is a bug in the documentation. From Metalink: Chapter 20 in the Oracle9i Database Concepts Release 2(9.2) Part Number: A96524-01 contains the following section: "You can set the ...

Not a bad trick. But to be shure what the actual length in bytes is, use the lengthb function in a query. This works of course only for Oracle, so it is not what you really want. Hard to try to be dbms-independent.