The _createSDOResultSet() method

You can call one of three overloaded versions of _createSDOResultSet(), which supports different combinations of the four factory method parameters.

The following version uses the KEEP_ROWS scrolling mode and the default where and sort expressions:

public SDOResultSet _createSDOResultSet(String sdoName)

The following version uses the KEEP_ROWS scrolling mode:

public SDOResultSet _createSDOResultSet(String sdoName, String where, 
   String sortBy)

The following version uses whatever scrolling mode is specified by parameters:

public SDOResultSet _createSDOResultSet(String sdoName, String where, 
   String sortBy, SDOParameters parameters)

For more information, see Understand SDOResultSet scrolling modes

The following parameters apply to _createSDOResultSet():

sdoName
(Required) Specifies the filename of the SmartDataObject (custSDO.w, for example).
where
Allows the application to open a query with a where expression that is different than the default one specified when the SmartDataObject was created. For more information, see the description of the setQueryWhere method in OpenEdge Development: ADM Reference.
sortBy

Allows the application to open a query with a sort expression that is different from the default one specified when the SmartDataObject was created. You can specify sortBy using one of the following syntax styles:

Syntax

"[field|field ASCEND |field DESCEND
        [ , {field|field ASCEND |field DESCEND }]...]"|"[field|field ASCEND |field DESCEND
        [ BY {field|field ASCEND |field DESCEND }]...]"
field
  • A valid database field referenced by the SmartDataObject. Specifying no fields ("") is equivalent to null. Examples include:

  • "Name"

  • "Name, City"

  • "Name DESCEND, City, Zip"

  • "Name BY City"

  • "Name DESCEND BY City BY Zip"

For more information on specifying field, see the description of the setQuerySort method in OpenEdge Development: ADM and SmartObjects.

parameters
Used for passing any additional initial parameters to the ResultSet object, such as the scrolling mode. If parametersdoes not specify a scrolling mode, the default is used.