MySQL Range Check Error table with many fields

In this forum we will discuss things relating the ZEOSLib 6.6.x stable versions

Moderators: gto, EgonHugeist

Post Reply
spijker
Fresh Boarder
Fresh Boarder
Posts: 3
Joined: 04.06.2010, 06:01

MySQL Range Check Error table with many fields

Post by spijker »

Hello

Using Zeos 666 with Delphi5 and MYSQL

I got a range check error with tables with many fields (>50 or so)
I can see the fields, but no records at all in the grid.

Other tables no connection problem.

Error exists in unit Unit ZplainMYSQLDriver

function TZMySQL5PlainDriver.GetFieldData(Row: PZMySQLRow;
Offset: Cardinal): PChar;
begin
Result := ZPlainMySql5.PMYSQL_ROW(ROW)[Offset];
end;

Any idea what to do?

Thanx in advance.
spijker
Fresh Boarder
Fresh Boarder
Posts: 3
Joined: 04.06.2010, 06:01

Post by spijker »

If found the error! The MYSQL table may not be larger than 256 fields...
jeremicm
Senior Boarder
Senior Boarder
Posts: 61
Joined: 18.10.2006, 17:07
Contact:

Post by jeremicm »

From my knowledge, if you have a table wih 256 fields, something is teribly wrong with your database design....
Post Reply