Description
A class for retrieving the result of a database SQL query.
A Database.ResultSet is returned by
Database.Connection.query(), and by
Database.PreparedStatement.execute().
The class provides methods and properties for retrieving the result data associated with a SQL query execution.
Database.Connection con = Database.Connection("DBConnector1");
con.connect();
Database.ResultSet result = con.query("SELECT * FROM customers");
while (result.fetchNext()) {
string firstName = result["FirstName"];
string lastName = result["LastName"];
for (int j = 1; j <= result.numFields; j++) {
Variant column1Value = result[j];
...
}
...
}
con.disconnect();
A Database.ResultSet implements a forward-only cursor. This means you can only traverse through the results once.
This can either be done manually, using fetchNext(), or automatically
by dumping the data to a table with cloneTo(). However, you cannot do
both. In other words, you cannot clone the result using cloneTo(), and then also use fetchNext() to traverse the result again,
or vice versa.
Properties
| numFields |
The number of fields in the result set. |
Methods
| cloneTo |
Clones the result set to a destination table. |
| fetchNext |
Moves the cursor forward one record in the result. |
| getFieldName |
Gets the name of a result column by index. |
Operators
| [] |
Gets a result field value by its name or rank. |
Do no remove, this fixes the anchor on doc.flexsim.com
| void cloneTo(
Table destTable
)
|
Description
Clones the result set to a destination table.
Database.Connection con = Database.Connection("DBConnector1");
con.connect();
con.query("SELECT * FROM customers").cloneTo(Table("Customers"));
con.disconnect();
Do no remove, this fixes the anchor on doc.flexsim.com
Parameters
| fieldNum |
The index of the field. |
Returns
|
string
|
The name of the field at the specified index. |
Description
Gets the name of a result column by index.
Array fields;
Database.Connection db = Database.Connection("DatabaseConnector1");
db.connect();
var resultSet = db.query("SELECT * FROM customers");
for (int i = 1; i <= resultSet.numFields; i++) {
fields.push(resultSet.getFieldName(i));
}
db.disconnect();
return fields;