A handle to a data-source object. A data-source object supports the automatic filling of a ProDataSet object member table, as well as applying updates back to one or more database tables. There is a distinct data-source object for each member buffer, which allows a single ProDataSet object and a single fill operation on that object to combine data from multiple databases. A data-source object is defined independently of any ProDataSet object.

A data-source object can be static or dynamic. A static data-source object is one you define at compile time with the DEFINE DATA-SOURCE statement. A dynamic data-source object is one you create at run time with the CREATE DATA-SOURCE statement. Use this handle to access the data-source object's attributes and methods.

Note: Does not apply to SpeedScript programming.

Syntax

data-source-handle [ :attribute | :method ]
data-source-handle
A handle variable that references a data-source object.
attribute
An attribute of the data-source object.
method
A method of the data-source object.

Attributes

ADM-DATA attribute FILL-WHERE-STRING attribute HANDLE attribute
INSTANTIATING-PROCEDURE attribute KEYS attribute MERGE-BY-FIELD attribute
NAME attribute NEXT-ROWID attribute NEXT-SIBLING attribute
NUM-SOURCE-BUFFERS attribute PREFER-DATASET attribute PRIVATE-DATA attribute
QUERY attribute RESTART-ROW attribute RESTART-ROWID attribute
SAVE-WHERE-STRING attribute TYPE attribute –

Methods

ADD-SOURCE-BUFFER( ) method GET-DATASET-BUFFER( ) method
GET-SOURCE-BUFFER( ) method –

Notes

  • To associate a query with a dynamic data-source object, use the QUERY attribute. To disassociate the query and data-source object, set the QUERY attribute to the Unknown value (?).
  • To override the WHERE clause in the query, use the FILL-WHERE-STRING attribute.
    Note: The FILL-WHERE-STRING attribute of the data source object only applies to the default data source query. It does not apply when a named query is specified using the QUERY attribute.

See also

CREATE DATA-SOURCE statement, DEFINE DATA-SOURCE statement