version 2004
PGSQL_GetResultStatus (resID; resultStatus) Longint
| Parameter | Type | Description | |
| resID | Longint | Result ID returned by PGSQL_Execute | |
| resultStatus | String | Status of the result | |
| Function result | Longint | Error code (where 0 means no error) |
Description
The PGSQL_GetResultStatus command gives the result status of the command. It returns an error code (Longint) where 0 means no error.
resultStatus can return one of the following values:
PGRES_EMPTY_QUERY -- The string sent to the backend was empty.
PGRES_COMMAND_OK -- Successful completion of a command returning no data. PGRES_TUPLES_OK -- The query successfully executed.
PGRES_COPY_OUT -- Copy Out (from server) data transfer started.
PGRES_COPY_IN -- Copy In (to server) data transfer started.
PGRES_BAD_RESPONSE -- The server's response was not understood.
PGRES_NONFATAL_ERROR
PGRES_FATAL_ERROR
resID is a Longint that corresponds to the result ID returned by PGSQL_Execute.
resultStatus is a String that is returned which corresponds to the status of the result.