Zeoslib Portal

Erik, I hope there's some developper responsible for the Monitor, that watches this thread. In my opinion it's a bug (that I can live with, but anyway...) as the behaviour is not consistent. If there's an event OnTrace/OnLogTrace, it should fire for every statement logged, no matter what happens. It...

Well, If the queries are not executed simultaneously I would not expect performance problems. For simultaneous queries probably more connections could help. On the other hand, if you use transactions, it's better to have 1 connection, as different connections do not see each others updates until a c...

The opening and closing of tables should be done by Mysql after processing the statement. But did you shut down the database server? As long as you do not shutdown or flush the tables (see Mysql Documentation) there's no guarantee that the table is physicaly closed. That's completely normal.

Mark

Erik, I use the tortoiseSVN software. ( http://tortoisesvn.tigris.org/ I think it's similar to CVS but newer. After installing (Windows) you will see a new option in windows explorer (right click menu) SVN Checkout... After clicking you get a small dialog asking for the repository. For Zeos you shou...

That means, both events fire, except for the queries generated to update the database rows? Is the data in the log file also missing these lines? If not it's just the triggering part that does not work. I would say it's a real bug in your ZEOS version for (at least) the protocol you use. Yesterday i...

I was a little curious what this ZSQLMetadata thing just is, so i did some tests. I created a new test project and i dropped 4 components on the form. ZConnection (choose protocol and set db parameters. Connected = true) ZSQLMetadata (choose connection) Datasource(set Dataset to Metadata component) ...

Hi, I can ansewer only first three questions as I'm only experienced in using mysql. 1 and 2 : use sql create statements in a tzsqlprocessor. That means, if you realy have to do it from your applications. This kind of stuff is usually done during the implementation of applications and by a dba (or a...

Sorry Erik, But I did not really onderstand that you were trying to catch the messages sent to the logfile of the SqlMonitor. Is the logfile correct or are the messages absent there as well? I don't know much about those stuff, but I've read the documentation about the dbExpress sqlMonitor and it ap...

To log the statements sent by ZEOS you should ude the TZSqlMonitor component of ZEOS . Just drop it on the form and set the connection property to the connection object you used for the SQL.

Mark

To create tables is probably less 'multidatabase', although a 'create table' statement is fairly 'standard' for most DBs.
The multidatabase part is mostly true for select/update/delete actions using the components without modifying the queries manually.

Mark

Do you 'open' the query? In case you don't want a resultset you should 'execute' the query instead of opening it. You can also use the ZsqlProcessor component.

Mark

In short this means that ZEOS should NOT raise an error when someone tries to insert null into a NOT NULL column having a default value on the database. At least not when dealing with Mysql. (I don't know the specifications of other DBs) For mysql it's not necessary to remove the field from the inse...

If it's Mysql 5.0, you should try to use the libmysql.dll of the 5.0 release instead of the 4.1 version (rename to libmysql41). Protocol in zeoslib connection should stay 4.1 until 5.0 is realy supported.

Mark

Hi, Josef. I'm not a firebird user at all, so it can be different there, but in mysql the user management works for all databases on the server. So, I think it all depends on the configuration of your specific server. I think the default user/password-combination for firebird is sysdba/masterkey, bu...

Hi MD, Zeos can't help you out here. The plugin has been written to use the BDE. If the plugin had been written using Zeos it wouldn't have needed the bde, just the DLL needed for connectivity with your database. So ZEOS is not a replacement for the BDE in itself. It merely provides a tool to avoid ...