Data Set Model: _setWhere

Data Set Model: _setWhere

Sets a WHERE clause on the table

Syntax
Details
Example

Syntax

CALL SEND (object-id, '_setWhere', where-list);

Argument Type Description

where-list
N specifies the identifier of an SCL list that contains the WHERE clause(s) to apply to the table

Argument	Type	Description
where-list	N	specifies the identifier of an SCL list that contains the WHERE clause(s) to apply to the table

Details

If you modify the current row in the table, you must use the _updateRow method before calling the _setWhere method.

The _setWhere method imposes one or more sets of conditions that rows in the table must meet. Rows that do not satisfy the specified conditions cannot be edited.

If you use the _addRow method to add a new row and the initial values for the row do not meet the WHERE conditions, the row cannot be fetched while the WHERE clause is in effect.

An empty list or a list with the single item 'CLEAR' clears the current WHERE clause.

If you augment a WHERE clause, the SCL list containing the augmentation must begin with ALSO

The _setWhere method cannot be used with the _setKey method.

The _setWhere method sets SYSRC for error, note, and warning conditions.

Example

In the following example, the Data Set Model class is being used as a stand-alone model, that is, the model class is not being used with a data form or data table object.

This example assumes you have created a FRAME entry with a push button object named BUTTON1:

INIT: datcl=loadclass('sashelp.fsp.datast_m.class'); datid=instance(datcl);

call send(datid, '_setDataset', 'sasuser.class'); return;

BUTTON1: listid=makelist(); listid=insertc(listid, 'Sex="M"', -1); listid=insertc(listid, 'and weight > 50', -1); call putlist(listid, 'WHERE clause=', 0); call send(datid, '_setWhere', listid); rc=clearlist(listid);

call send(datid, '_getWhere', listid); call putlist(listid, 'WHERE List=', 0); listid=dellist(listid); return;

TERM: call send(datid,'_term_'); return;

Chapter Contents
Previous
Next
Top of Page