Specifies that the retrieved data set is cached in a file, allowing previous navigation and random seek. It requires the Load and NextRow methods to display data.

Specifies that the retrieved data set uses a DBMS cursor, allowing nested queries. It requires the Load and NextRow methods to display data.

Specifies that the retrieved data set is returned as in a select loop. It precludes nested queries because a single select statement is in effect between the Open and Close of the DataStream object. It also requires the Load and NextRow methods to display data.

Specifies that the retrieved data set is immediately loaded into the specified table field or local array by the Open method (making the Load and NextRow methods meaningless). It requires the UpdField method to refresh the display.

Using QY_ARRAY mode enhances performance if you are loading a table field because an entire array of data is loaded. However, to take advantage of the enhanced performance, the class of the array being loaded must have attribute names that match the names of the columns in the query (which can differ from the names of columns in underlying database tables, due to "as" clauses).