Advantage TDataSet Descendant
Specifies the text of the beginning scope for a dataset.
property ScopeBegin: string;
Use ScopeBegin to specify an indexed dataset filter. When ScopeBegin is applied to a dataset, only those records following the ScopeBegin are available to an application. ScopeBegin contains the string that is the value for the index. For example, the following ScopeBegin string displays only those records and following where the indexed State field is anything after CA. Programmatically set:
AdsTable1.ScopeBegin := ‘CA’;
To set a scope on indexes built on date, time, or timestamp fields, the date and time values must be formatted as text. The date should be formatted according to DateFormat. For example, to set a scope on a date index, an application might use "2/25/1997" as the value. To set a scope on a timestamp index, the value could be "2/25/1997 3:25pm".
ScopeBegin can be used in conjunction with ScopeEnd.
Note Ranges are implemented internally as scopes. Ranges provide a very useful means to automatically produce the value necessary to set the scope. For this reason, use of ranges is easier and more versatile.