Page 1 of 1

MySQL Range Check Error table with many fields

Posted: 04.06.2010, 13:32
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.

Posted: 04.06.2010, 14:25
by spijker
If found the error! The MYSQL table may not be larger than 256 fields...

Posted: 05.06.2010, 09:56
by jeremicm
From my knowledge, if you have a table wih 256 fields, something is teribly wrong with your database design....