TAstaClientDataSet.SQLOptions

Declaration
property SQLOptions: TAstaSelectSQLOptionSet;

Description
When the soFetchMemos or soFetchBlobs subproperty is set to True, memo fields can be automatically fetched from a select statement. There are performance considerations when using this feature, particularly over a WAN connection, so please use it with caution. Any field that is a TMemo will be streamed from the server to the client. Please understand that overhead will be incurred when you use this feature. To activate the automatic fetching of memo fields, set the AstaDataDataSet.SQLOptions.soFetchMemos subproperty to True.

When EditMode is set to umAfterPost or umCached, and soFetchMemos and/or soFetchBlobs is set to true, then ASTA will automatically generate parameterized queries to insert or update to any blob or memo fields that are not tagged as readonly.

Tip: for performance purposes you may want to turn soFetchMemos/soFetchBlobs to false when you do your select but then activate them after the AstaClientDataSet is opened so that any local edits and appends of Blobs or Memos are posted to the server in a parameterized query.

Example

AstaClientDataset.SQLOptions:=AstaClientDataSet.SQLOptions+[soFetchMemos,soFetchBlobs];