Rowset.executeQuery()

note

This article is about the executeQuery() function of the Rowset object.

Rowset.executeQuery()

Executes a query specifically for the rowset. Existing queried data (if any) is cleared before the query is executed.

Returns a Promise object or the 'this' object. From USoft 10.0.1I, returns a udbPromise instead of a Promise object.

Syntax

$.*row-set*.executeQuery( *options* )

*options*  ::=  {
     hostvars:  *hostvars*,
     nocheck:  *nocheck*,
     orderBy:  *order-by*,
     before:  *before-function*,
     promise:  *promise*,
     success:  *success-function*,
     error:  *error-function*
}

*hostvars*        ::=  { *name* : *value*, ... }

*nocheck*         ::=  { true | false }

*order-by*        ::=  *order-col*, ...
*order-col*       ::=  { *col-name* | *col-sort-order* }
*col-sort-order*  ::=  { *col-name* : *sort-order* }
*sort-order*      ::=  { ASC | DESC }

*promise*         ::=  { true | false }

For an explanation of options, please go to the $.udb(ds).executeQuery() article.

Example

var rowSet = $.udb(this.dsId).rowSet(pRef);
rowSet.executeQuery().then(function() {
  ...
});