MicroStrategy ONE

ExecuteCapture

Executes a Command Manager statement, with the intent of storing the results of a LIST operation in a ResultSet object. For information about retrieving information from the ResultSet object, see Retrieving information from ResultSet objects.

Copy
protected ResultSet executeCapture(iString)

where:

iString is the Command Manager statement to be executed. This statement can contain both literal strings enclosed in double quotes (") and variables, concatenated with the + operator.

Example

This sample uses the executeCapture function and a ResultSet object to display a list of MicroStrategy users that have been disabled.

Copy
// Query the usersResultSet lUsers =
printOut("There are " +
lUsers.moveFirst();
while (!lUsers.isEof())
{
  Boolean lEnabled = (Boolean)
  // Log the users based on some condition
  if ((lEnabled != null)  (!
  {
    String lLogin = (String)
    printOut("User " +
  }
  lUsers.moveNext();
}