Row buffer width exceeded. Try using fewer or longer columns

[ffabian]

Hello everyone, this is my first post on Zeos.

I have zeos 7.0.0 and Delphi 2009

When a table has many fields and the total width of all is greater than 32767 the table can not be opened.

I think this would be ok if the table is HeidiSQL.
In firebird should not have this limit.

In version 6.6.6. I do not have that problem but I can not use Delphi 2009

The problem is in \src\dbc\ZDbcCache.pas line 242
// Is the length of 32,768 to TByteArray. (HeidiSQL patch)
if FColumnsSize > 32767 then
begin
raise EZSQLException.Create(SRowBufferWidthExceeded);
end;

Thank you

[sinocencio]

Good morning.

I'm having the same problem, I am using Delphi 2010 and had to comment about the specified line in order to use the zeos7 for Delphi 2010, if possible would like to know if there is already a solution for this problem

Thank you

[mdaems]

ffabian,

HeidiSQL is not a database but a mysql database admin tool that used zeoslib as it's database connection components. They did this patch because there's trouble later on when larger buffers are created. I can't remember exactly what the reasons were, but I suppose there are places where integers are used to reference the data at specific places in the buffers.

Probably this gives more trouble in D2010 as there all strings are longer unicode strings. I'm afraid you'll have to check why in zeoslib7+D2010 you're geting this large buffers so easily.

Mark