Data.SqlExpr.TSQLQuery.MaxBlobSize
Delphi
property MaxBlobSize: Integer read FMaxBlobSize write SetMaxBlobSize default 0;
C++
__property MaxBlobSize = {default=0};
Properties
| Type | Visibility | Source | Unit | Parent |
|---|---|---|---|---|
| property | published | Data.SqlExpr.pas Data.SqlExpr.hpp |
Data.SqlExpr | TSQLQuery |
Description
Indicates the maximum number of bytes fetched for any BLOB field in the dataset.
Data.SqlExpr.TSQLQuery.MaxBlobSize inherits from Data.SqlExpr.TCustomSQLDataSet.MaxBlobSize. All content below this line refers to Data.SqlExpr.TCustomSQLDataSet.MaxBlobSize.
Indicates the maximum number of bytes fetched for any BLOB field in the dataset.
MaxBlobSize limits the amount of data that can be fetched from Binary Large Object (BLOB) fields. BLOB fields can hold an indefinite amount of data. However, SQL datasets read that data into a memory buffer. By limiting the amount of data that can be fetched from a BLOB field, you limit the size of the buffer.
If MaxBlobSize is –1, the dataset imposes no maximum BLOB size. If MaxBlobSize is 0, the dataset uses the parameters of the associated SQL connection, if any, to determine the maximum BLOB size.
Note: MaxBlobSize should agree with any parameters on the associated SQL connection component that limit the size of BLOB data.