The _createSDOResultSet() method
- Last Updated: August 15, 2021
- 1 minute read
- OpenEdge
- Version 12.2
- Documentation
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:
|
The following version uses the KEEP_ROWS scrolling
mode:
|
The following version uses whatever scrolling mode is specified by 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
setQueryWheremethod 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
setQuerySortmethod in OpenEdge Development: ADM and SmartObjects. -
- parameters
- Used for passing any additional initial parameters to
the ResultSet object, such as the scrolling mode. If parameters
does not specify a scrolling mode, the default is used.