#77 Access violation for TEXT, LARGETEXT, SMALLTEXT and CAST as CHAR[n] where n > 500 Fields

[Little Earth Solutions]

Access violation for TEXT, LARGETEXT, SMALLTEXT and CAST as CHAR[n] where n > 500 Fields

Access violation will exit here:

function TZMySQLBaseDriver.GetFieldData(Row: PZMySQLRow;
Offset: Cardinal): PAnsiChar;
begin
Result := PMYSQL_ROW(ROW)[Offset];
end;

This can be easily replicated in the zeoslib test tables. Add some rows of text in the b_text field in table blob_values. I added 62 rows containing the text from lgpl.txt

Add a ZConnection, ZQuery, Datasource and link a DBGrid

ZQuery.SQL.Clear;
ZQuery.SQL.Add('SELECT * FROM blob_values');
ZQuery.Open;

Demo application attached.

[EgonHugeist]

Hi Tristan,

before testing your app.. Could you please update from SVN? Thought i resolved this issue on commit 3158 (as i noticed you thread in the Forum, i'm sorry for my absence there. Out of time to post there)

Cheers, Michael

[Little Earth Solutions]

Hi Michael,
My testing so far would show the issue has been resolved. No need to apologize you do great work for ZeosLib.
Tristan

[EgonHugeist]

Thanx for your feedback. Did omit this TZUncachedLob descendant for postgre too (OID lobs do work pretty nice, of course).

Ticket closed, Michael