range check error

[oguzy]

I tried Zeos ZEOSDBO-6.6.6-stable with Delphi 7. Compiled the dbg and installed the components. I was able to connect to the local mysql database but when i entered a query i got "Range check error"

My mysql version is: 5.1.36 and i am using wamp at my system.
I installed the libmysql.dll from this address: http://delphi.about.com/gi/o.htm?zi=1/X ... /0010.php3

I tried DBGrid to see the entries at the table.

Will be happy if there is any solution.

[mparak]

How many fields are you selecting. ?

M

[Werner3112]

Is there a limit on the number of columns/fields.

[EgonHugeist]

Werner3112,

normaly not. But actually we support only 32KB/row in \testing or \trunk and 64kb/row in \testing-egonhugeist. Which means there is no column limitation but a memory limitation..

Michael

[shiva4]

Hello!
I had the same problem. There is a table in mysql where the number of columns is greater than 128, the same error occurs. How to solve it?

[marsupilami]

Hello shiva4,

which verson of Zeos did you use?

With best regards,

Jan

[shiva4]

Hi!
I would like to clarify. I have a table with 386 columns and this is not the limit that can be. on this amount I have an error

the version I'm using ZEOSDBO-7.1.4-stable

[shiva4]

when there were 176 fields it worked

[marsupilami]

Could you please try the current Zeos 7.2 from SVN?

[shiva4]

Well I'll try and write about the result later

[shiva4]

As it turned out, I had version 6.6.5-stable. I work with delphi5 and as I understand the version above 6.6.5 it is not supported. In any case, the delphi5 directory does not exist and it is impossible to install from another directory

[shiva4]

The error appears from the ZPlainMySqlDriver module in function TZMySQL5PlainDriver.GetFieldData

Going further I found

in the module zplainMySql5 I found

MYSQL_ROW = array [00 .. $ ff] of PChar;

This is the restriction in connection with which this error arises.


I do not know if it's enough to change the code in this place and recompile the components if possible

[shiva4]

Looked in the source files of version 7.2.0 this restriction remains.

file ZPlainMySqlConstants.pas

string

MYSQL_ROW = array [00 .. $ ff] of PAnsiChar;

[EgonHugeist]

fixed. R4171 \tesing-7.2.

Thanks for the report