Zeoslib Portal

I have problems installing it. Pls give short instructions. Thanks

mdaems wrote:Try the attached patched files.

Sorry, how can I download this patch?

Edit: Download function was disabled.

Filter your data with the where clause of your query.

mdaems wrote:Yes, it's possible.
No, I'm not really willing to do it. (But you can patch your version using the change above).

Ok, I just spent a couple of hours to change our database, so the only problem remaining is the default value stuff. If you're going to fix this, everything is fine again.

mdaems wrote:Your opinion?

6.6.1-beta is doing fine. Isn't it possible to restore it's behaviour into the new Zeos?

gto wrote: Please open a bug in Mantis, then I can help you resolving it

Done. See http://zeosbugs.firmos.at/view.php?id=90

Did you try setting default values on the table? Not sure if zeoslib takes those into account, however. Also, default values are ignored. At least these should be used by Zeos. What about dropping the not null constraint? As mysql is 'ig noring' or fixing it anyway it doesn't make much sense in you...

gto wrote: Well, you're creating a table with four fields, and all of them are NOT NULL, which means you must fill a value for them! Am I right?

You're right. But plain MySQL also works, and because it worked with Zeos also since latest rc I would have to change quite a lot of stuff.

Hi Mark,

mdaems wrote:Do you mean this behaviour changed between 6.6.1 and 6.6.2?

Yes.

As I see this : this behaviour is correct. What did 6.6.1 beta insert when the post was executed?

INSERT INTO test.test (id,s1,s2,s3) VALUES (0,'','','')

I just have installed ZEOSLIB_TESTING_REV329.zip (alos happens with ZEOSDBO-6.6.2-rc.zip) and the following error happens: Default values are not fetched correctly from the table when I use the following example: With q1 do begin Close; Sql.Clear; Sql.Add('drop table if exists test'); ExecSQL; Sql.C...

mdaems wrote:please log a bug report at the bug tracker

Done: http://zeosbugs.firmos.at/view.php?id=76

I'm using Delphi 7, MySQL 5.0.44 and ZEOSLIB_TRUNK_REV310.zip The properties of the TZConnection are MYSQL_SSL=TRUE MYSQL_SSL_CA=c:/newcerts/ca-cert.pem MYSQL_SSL_CERT=c:/newcerts/client-cert.pem MYSQL_SSL_KEY=c:/newcerts/client-key.pem When I try to connect, I get a SSL Connection Error. With MySQL...

Thanks, seems to work.

Pls, anyone?

Any news on this one?