Devart Forums

Hello support,
I'm using a TMyTable component and this component shows e.g. 10 records in a grid, but not the blob field (document). Are the blobs of each record loaded when the records are shown in the gird or are the blob fields loaded when the record is active/located?

Thanks for your help

If you use default settings then all data from BLOB fields is fetched from server on DataSet open

and how could I change the behavior?

Thanks

No, this is MySQL client-server protocol limitation.

As a little trick i setup a master-detail relation of the same table, on master i select all except blob fields, on detail I select blob fields+masterkey. I use a lot of faxing and doc scanning stuff, and with this it's really fast to browse a list.