|
Whitebeam Object Definition
|
PgsqlResult Object Description
This class encapsulates the result of a Postgres database operation, executed through PgsqlConnection.exec(SQL_statement).
Instances of this class contain the basic status information providing success/failure of an operation,
and also an interface to read individual row information from a SQL query. Details of how to us the Whtebeam Postgres interface can be found in our tutorial dealing with this specific topic. Also see PgsqlConnection Methods
Object Properties
Name | Type/Value | Range/Length | Description | success | bool | | Required.
The success (true) or failure (false) status of this request. If this is 'true' then Postgres reported no errors with the operations executed on the database.
| status | string | | Required.
Returns a string representation of operation result code stored in the PgsqlResult object.
| error | string | | Required.
If PgsqlResult.success has the value 'false' (the database operation failed) then this property will contain a human readable description of the error that occurred. This
will contain an empty string if the operation succeeded.
| numRows | number | | Required.
The number of rows returned in a SQL query. This value will be zero for operations that update database (INSERT etc). This returns the number of rows of a table
returned, for example, as the result of a SELECT query.
| affectedRows | number | | Required.
Number of rows changed by a SQL operation.
|
|
|
(loadtime : 18ms) |