Platforms to show: All Mac Windows Linux Cross-Platform
Back to PostgreSQLAPIMBS class.
PostgreSQLAPIMBS.DB as string
Function:
The database name used to create the connection.
| Type | Topic | Plugin | Version | macOS | Windows | Linux | iOS | Targets |
| method | SQL | MBS SQL Plugin | 9.8 | ✅ Yes | ✅ Yes | ✅ Yes | ✅ Yes | All |
PostgreSQLAPIMBS.ErrorMessage as string
Function:
The last error message.
| Type | Topic | Plugin | Version | macOS | Windows | Linux | iOS | Targets |
| method | SQL | MBS SQL Plugin | 9.8 | ✅ Yes | ✅ Yes | ✅ Yes | ✅ Yes | All |
PostgreSQLAPIMBS.Field(cmd as SQLCommandMBS, RecordIndex as Integer, FieldIndex as Integer) as string
Function:
Queries a field by index for the row with the RecordIndex.
| Type | Topic | Plugin | Version | macOS | Windows | Linux | iOS | Targets |
| method | SQL | MBS SQL Plugin | 9.8 | ✅ Yes | ✅ Yes | ✅ Yes | ✅ Yes | All |
See also:
PostgreSQLAPIMBS.Field(cmd as SQLCommandMBS, RecordIndex as Integer, FieldName as string) as string
Function:
Queries a field by name for the row with the RecordIndex.
| Type | Topic | Plugin | Version | macOS | Windows | Linux | iOS | Targets |
| method | SQL | MBS SQL Plugin | 9.8 | ✅ Yes | ✅ Yes | ✅ Yes | ✅ Yes | All |
See also:
PostgreSQLAPIMBS.FieldCount(cmd as SQLCommandMBS) as Integer
Function:
The number of fields in the result.
| Type | Topic | Plugin | Version | macOS | Windows | Linux | iOS | Targets |
| method | SQL | MBS SQL Plugin | 9.8 | ✅ Yes | ✅ Yes | ✅ Yes | ✅ Yes | All |
PostgreSQLAPIMBS.Host as string
Function:
The host used to create the connection.
| Type | Topic | Plugin | Version | macOS | Windows | Linux | iOS | Targets |
| method | SQL | MBS SQL Plugin | 9.8 | ✅ Yes | ✅ Yes | ✅ Yes | ✅ Yes | All |
PostgreSQLAPIMBS.Options as string
Function:
The options used to create the connection.
| Type | Topic | Plugin | Version | macOS | Windows | Linux | iOS | Targets |
| method | SQL | MBS SQL Plugin | 9.8 | ✅ Yes | ✅ Yes | ✅ Yes | ✅ Yes | All |
PostgreSQLAPIMBS.Password as string
Function:
The password used to create the connection.
| Type | Topic | Plugin | Version | macOS | Windows | Linux | iOS | Targets |
| method | SQL | MBS SQL Plugin | 9.8 | ✅ Yes | ✅ Yes | ✅ Yes | ✅ Yes | All |
PostgreSQLAPIMBS.Port as string
Function:
The port used to create the connection.
| Type | Topic | Plugin | Version | macOS | Windows | Linux | iOS | Targets |
| method | SQL | MBS SQL Plugin | 9.8 | ✅ Yes | ✅ Yes | ✅ Yes | ✅ Yes | All |
PostgreSQLAPIMBS.RecordCount(cmd as SQLCommandMBS) as Integer
Function:
The number of records in the result.
| Type | Topic | Plugin | Version | macOS | Windows | Linux | iOS | Targets |
| method | SQL | MBS SQL Plugin | 9.8 | ✅ Yes | ✅ Yes | ✅ Yes | ✅ Yes | All |
Some examples using this method:
PostgreSQLAPIMBS.TTY as string
Function:
The tty used to create the connection.
| Type | Topic | Plugin | Version | macOS | Windows | Linux | iOS | Targets |
| method | SQL | MBS SQL Plugin | 9.8 | ✅ Yes | ✅ Yes | ✅ Yes | ✅ Yes | All |
PostgreSQLAPIMBS.User as string
Function:
The user name used to create the connection.
| Type | Topic | Plugin | Version | macOS | Windows | Linux | iOS | Targets |
| method | SQL | MBS SQL Plugin | 9.8 | ✅ Yes | ✅ Yes | ✅ Yes | ✅ Yes | All |
The items on this page are in the following plugins: MBS SQL Plugin.
