Zeoslib Portal

You can also start mysqld with --old-passwords or put old-passwords into my.ini in the [mysqld] section.

Hi Michael,

Thanks for your remark, but what exactly do you mean?

Hi!
Never use a ZTable (any TTable) for such a big table. Use a ZQuery with the SQL you mentioned inside. In fact, always try to avoid TTable.
Regards,
Rüdiger

Hi!
What is the real value in your table? Have you seen it with other utilities?
Have you tried ZSQLMonitor? Sometimes it helps.
Regards,
Rüdiger

Hi Mac! Which new client version? MySQL client? Or your program? Did you use different db connection components before? Oh yes, BDE/ODBC. That should be slower than Zeos (ODBC!). But if I am right, now you use on both systems Zeos components, so it can't be that. Is the database in both cases the sa...

Hi! Maybe your customer has simply more data? That's a quite normal difference between test and production systems... Have you tried to issue the same queries on those system using the mysql command line tool or MySQL Browser and noticed some performance differences? Maybe some more indexes would he...

Hi! From the MySQL Manual: Automatic updating of the first TIMESTAMP column occurs under any of the following conditions: * The column is not specified explicitly in an INSERT or LOAD DATA INFILE statement. * The column is not specified explicitly in an UPDATE statement and some other column changes...

Most of the time I do it this way: The Datamodule is created before the Main Form. To do this, I have to change the project (.dpr) file. Connection.Connected is false. In FormCreate of the main form I set the necessary connection parameters: username (maybe OS user), if ParamStr(1) = TEST I connect ...

Why not set connected to FALSE before compiling? So you can do everything you want in runtime (in Form.Create or Button.Click or where you need it) before setting it to TRUE again and so opening the connection.

Will be hard. Quite all depend on TDataSet. Well, maybe you can use the underlying Zeos Classes beginning with ZDbcConnection, but not the visual components. I think somewhere on this site is documentation about Zeos' Architecture. Or was it AnyDAC (http://www.da-soft.com)? Also free, but with the s...

It works with D2005, but with no personal edition. Many classes inherit from TDataSet in DB.pas, which is, as far as I know, not included in personal editions.

This is for Delphi, but should be the same for BCB: You only need to install design time packages (where the components you se on the palette are in), in this case ZComponent. The other ones you only have to compile. It's written in the installation instruction in which order you have to do it.

Hi!
This has been posted here before. So far as I remember: remove all older ZEOS files (mainly .bpl). ZComponent.bpl must be running into some old ZPlain.bpl where it doesn't find the entry point (Ponto de entrada, as it clearly says) it is looking for.

HTH
Rüdiger

Hi! A user has to exist before he can connect, evidently. You have to create him first. The easiest way to do that would be using MYSQL Administrator. Best to create the database right now too (under Catalogs) and grant the new user rights to it. Mark is right, now try it out with mysql.exe on the c...

Hi Attila,
Yes, I think you are right. It would be easier, it is only one directory.

Greetings,
Rüdiger