Zeoslib Portal

ManUtdFans , we broke with the old package names. I suggest you use the new packages now, because some files are added/removed. If you use the old packages, you won't be able to compile Zeos7 So am I going to uninstall my previous Zeos? Download the new Zeos package (use SVN), then install the new ...

I have installed Zeos package with version 2 years ago in D2007. The folders under packages...delphi11 Now have created SVN with latest update, however, from the ...\Trunk There is a folder Delphi2007 (no delphi11 anymore). It looks I need to copy all the files under Delphi2007 into my original delp...

Just additional info:

Zeos release I am using is 6.6.4 (2008) that's from Changes.pdf come with the package.

josimarz , ManUtdFans , nope this i think is an bug on our MySQL definition. Don't have a testccase now but what i can see in the ZDbcMySQLUtils.pas is that type defined as stBinaryStream which means we try to write into a lob which doesn't exits. simply exchange the stBinaryStream with stSmallInt....

ManUtdFans , hmm whats left to say? Time to update and using Tortoise!! :) Michael Hi, So after I do an update (via tortoise), then copy the files into my Zeos installed folder? Edit:- yes of course I need to make a back up of my installatin folder first: - back up my Zeos 6.6.4 installation folder...

ManUtdFans , this is never a good idea i think. Only if a stable candidate was released. On the other hand you miss all fixes which have been allready done and you're forced to fix them by your selves. Also are we not willing to build suh an package each times after fixing something. I hope you can...

In addition, if I use the query for retrieving the contents, how should I compare? eg with Query1 do begin Close; SQL.Clear; SQL.Add('select Name, IsNew from employee'); Open; First; if FieldByName('IsNew').AsInteger = 1 then Showmessage('Employee is new') else Showmessage('Employee is NOT new'); I ...

Is there a component suite for the latest build such as in the old days to install the whole package?

ManUtdFans , i patched this stupid issue in Rev 155x?? Don't know if you've recognized it. We moved our SF.NET location. New url for the testing-branch is: http://svn.code.sf.net/p/zeoslib/code-0/branches/testing can you please check if that issue is gone? Michael I have not updated Zeos since 2009...

josimarz wrote:Hi,

Verify your MySQL version. "Before 5.0.3, BIT is a synonym for TINYINT(1).".
Source: http://dev.mysql.com/doc/refman/5.0/en/ ... rview.html

Josimar

Hmm, we are using 5.x, newer than 5.0.3.

josimarz , ManUtdFans , nope this i think is an bug on our MySQL definition. Don't have a testccase now but what i can see in the ZDbcMySQLUtils.pas is that type defined as stBinaryStream which means we try to write into a lob which doesn't exits. simply exchange the stBinaryStream with stSmallInt....

Hi,

We are using MySQL 5 and have a table field defined as Bit for using as Boolean equivalent.

I tried to write by using:
Query1.ParamByName('IsDue').AsBoolean := 1;
Query1.ParamByName('IsDue').AsSmallIn := 1;
Query1.ParamByName('IsDue').Value := 1;

All did not work.

I have asked the same question got some feedback but cannot complete my question. I am using Windows XP (SP 3) and Delphi 2007. Got the way to connect to MySQL by setting the properties: Properties.Strings = ( 'MYSQL_SSL=TRUE' 'MYSQL_SSL_CA=D:/mysql/certs/ca-cert.pem' 'MYSQL_SSL_CERT=D:/mysql/certs/...

Does anyone here successfully connecting to MySQL via SSL?

Anyone has any experience or knowledge about these please?