api:dk11:delphi:gisdblibpq.tgis_dblibpq
Table of Contents
TGIS_DbLibpq class
DK11 for Delphi | GisDbLibpq.TGIS_DbLibpq | Classes | Constructors | Fields | Methods | Properties
Class that can read PostgreSQL.
Available also on: .NET.
Syntax
// Delphi type TGIS_DbLibpq = class( TGIS_DbAbstract ) end;
// C++ Builder class PASCALIMPLEMENTATION TGIS_DbLibpq : public TGIS_DbAbstract { };
Inheritance
→ TObject → TGIS_ObjectDisposable → TGIS_DbAbstract
Constructors
Inherited
Overrides
Protected
Private
| Name | Visibility | Description | |
|---|---|---|---|
| Create | public | Constructor. (Overrides TGIS_DbAbstract.Create) |
|
Fields
Inherited
Protected
Private
| Name | Visibility | Description | |
|---|---|---|---|
| FDialect | protected | SQL dialect name. (Inherited from TGIS_DbAbstract) |
|
| FFullSafeParam | protected | if True, prefix with name is returned, otherwise only prefix. (Inherited from TGIS_DbAbstract) |
|
| FGeometryType | protected | Internal geometry type. (Inherited from TGIS_DbAbstract) |
|
| FiCodePage | protected | CodePage stored for optimization purposes. (Inherited from TGIS_DbAbstract) |
|
| FiJoinCodePage | protected | JoinCodePage stored for optimization purposes. (Inherited from TGIS_DbAbstract) |
|
| FInBatchMode | protected | True, if batch mode is enabled. (Inherited from TGIS_DbAbstract) |
|
| FisDb2 | protected | Is DB2 dialect. (Inherited from TGIS_DbAbstract) |
|
| FisInformix | protected | Is Informix dialect. (Inherited from TGIS_DbAbstract) |
|
| FIsInitializedProvider | protected | Is provider initialized. (Inherited from TGIS_DbAbstract) |
|
| FisInterbase | protected | Is Interbase dialect. (Inherited from TGIS_DbAbstract) |
|
| FIsJDBC | protected | if True, JDBC is used. (Inherited from TGIS_DbAbstract) |
|
| FisMsJet | protected | Is MsJet dialect. (Inherited from TGIS_DbAbstract) |
|
| FisMsSql | protected | Is MsSql dialect. (Inherited from TGIS_DbAbstract) |
|
| FisMySql | protected | Is MySql dialect. (Inherited from TGIS_DbAbstract) |
|
| FisOracle | protected | Is Oracle dialect. (Inherited from TGIS_DbAbstract) |
|
| FisPostgreSql | protected | Is PostgreSQL dialect. (Inherited from TGIS_DbAbstract) |
|
| FisSqlite | protected | Is Sqlite dialect. (Inherited from TGIS_DbAbstract) |
|
| FisSybase | protected | Is Sybase dialect. (Inherited from TGIS_DbAbstract) |
|
| FMultiUserMode | protected | MultiUser mode. (Inherited from TGIS_DbAbstract) |
|
| FNameMaxLength | protected | Sql name max length. (Inherited from TGIS_DbAbstract) |
|
| FOnSQLExecute | protected | SQL execute event handler. (Inherited from TGIS_DbAbstract) |
|
| FParameterPrefix | protected | Sql parameter prefix. (Inherited from TGIS_DbAbstract) |
|
| FRowsetSize | protected | Number of rows fetched in batches from the cursor database (default 0). (Inherited from TGIS_DbAbstract) |
|
| FUseTextParameters | protected | Use text parameters. (Inherited from TGIS_DbAbstract) |
|
| options | protected | Engine options. (Inherited from TGIS_DbAbstract) |
|
Methods
Inherited
Overrides
Protected
Private
| Name | Visibility | Description | |
|---|---|---|---|
| cursorClose | public | Free cursor allocated by CursorOpen(). (Overrides TGIS_DbAbstract.cursorClose) |
|
| cursorOpen | public | Allocate new cursor. (Overrides TGIS_DbAbstract.cursorOpen) |
|
| FinalizeProvider | public | Finalize provider. (Overrides TGIS_DbAbstract.FinalizeProvider) |
|
| getLastCursor | public | Get last opened cursor index. (Overrides TGIS_DbAbstract.getLastCursor) |
|
| GetLastErrorMessage | public | Return last error message text. (Overrides TGIS_DbAbstract.GetLastErrorMessage) |
|
| InitializeProvider | public | Initialize provider. (Overrides TGIS_DbAbstract.InitializeProvider) |
|
| PreRecognize | public | Check if layer can read a file. (Inherited from TGIS_DbAbstract) |
|
| safeParam | public | Get a safe parameter. (Inherited from TGIS_DbAbstract) |
|
| sqlBaseFolder | public | Return base folder for a layer. (Inherited from TGIS_DbAbstract) |
|
| sqlBindField | public | Obtain a bind number for a given field name. (Overrides TGIS_DbAbstract.sqlBindField) |
|
| sqlBuild | public | Build new SQL layer. (Overrides TGIS_DbAbstract.sqlBuild) |
|
| sqlConnect | public | Open database connection. (Overrides TGIS_DbAbstract.sqlConnect) |
|
| sqlCreateFunction | public | Create a function on database site. (Inherited from TGIS_DbAbstract) |
|
| sqlDisconnect | public | Close database connection. (Overrides TGIS_DbAbstract.sqlDisconnect) |
|
| sqlExec | public | Execute a command. (Overrides TGIS_DbAbstract.sqlExec) |
|
| sqlGetBindedField | public | Get the field value for a shape given by a unique identity. (Overrides TGIS_DbAbstract.sqlGetBindedField) |
|
| sqlGetParams | public | Get parameters list. (Overrides TGIS_DbAbstract.sqlGetParams) |
|
| sqlInitialize | public | Initialize database flags and options. (Inherited from TGIS_DbAbstract) |
|
| sqlLastInsertId | public | Get last inserted record id. (Inherited from TGIS_DbAbstract) |
|
| sqlPathAbsolute | public | Resolves potentially emebeded database path in a connection string into an abolute path. (Inherited from TGIS_DbAbstract) |
|
| sqlQueryClose | public | Close the query. (Overrides TGIS_DbAbstract.sqlQueryClose) |
|
| sqlQueryEof | public | Test for Eof on query. (Overrides TGIS_DbAbstract.sqlQueryEof) |
|
| sqlQueryGeometryIsText | public | Is geometry data a text. (Overrides TGIS_DbAbstract.sqlQueryGeometryIsText) |
|
| sqlQueryGetBlob | public | Get blob data type. (Overrides TGIS_DbAbstract.sqlQueryGetBlob) |
|
| sqlQueryGetField | public | Get a field from the query by field name. (Overrides TGIS_DbAbstract.sqlQueryGetField) |
|
| sqlQueryGetFieldById | public | Get a field from the query by field id. (Overrides TGIS_DbAbstract.sqlQueryGetFieldById) |
|
| sqlQueryGetFieldIndex | public | Get field index from query. (Overrides TGIS_DbAbstract.sqlQueryGetFieldIndex) |
|
| sqlQueryGetGeomObj | public | Get a geometry object from the query. (Overrides TGIS_DbAbstract.sqlQueryGetGeomObj) |
|
| sqlQueryGetGeomPtr | public | Get a geometry from the query. (Overrides TGIS_DbAbstract.sqlQueryGetGeomPtr) |
|
| sqlQueryGetGeomVAR | public | Get a geometry from the query. (Overrides TGIS_DbAbstract.sqlQueryGetGeomVAR) |
|
| sqlQueryGetGEOUID(Integer; Integer) | public | Get a GEO.UID from the query. | |
| sqlQueryGetGEOUID(String; Integer) | public | Get a GEO.UID from the query. | |
| sqlQueryGetSHAPETYPE | public | Get a SHAPETYE from the query. (Overrides TGIS_DbAbstract.sqlQueryGetSHAPETYPE) |
|
| sqlQueryGetXMIN | public | Get a XMIN from the query. (Overrides TGIS_DbAbstract.sqlQueryGetXMIN) |
|
| sqlQueryGetYMIN | public | Get a YMIN from the query. (Overrides TGIS_DbAbstract.sqlQueryGetYMIN) |
|
| sqlQueryMoveFirst | public | Move to first record of query. (Overrides TGIS_DbAbstract.sqlQueryMoveFirst) |
|
| sqlQueryMoveNext | public | Move to next record of query. (Overrides TGIS_DbAbstract.sqlQueryMoveNext) |
|
| sqlQueryNameGEOUID | public | Get a GEO.UID field from the query. (Overrides TGIS_DbAbstract.sqlQueryNameGEOUID) |
|
| sqlQueryOpen | public | Open the query. (Overrides TGIS_DbAbstract.sqlQueryOpen) |
|
| sqlQueryReset | public | Reset current sql query. (Overrides TGIS_DbAbstract.sqlQueryReset) |
|
| sqlQueryStructure | public | Fill the current layer structure based on the query. (Overrides TGIS_DbAbstract.sqlQueryStructure) |
|
| sqlQueryUnPrepareGetGeom | public | Unprepare geometry access. (Overrides TGIS_DbAbstract.sqlQueryUnPrepareGetGeom) |
|
| sqlTableAppend | public | Append a new record into the table. (Overrides TGIS_DbAbstract.sqlTableAppend) |
|
| sqlTableClose | public | Close the table. (Overrides TGIS_DbAbstract.sqlTableClose) |
|
| sqlTableCreateParam | public | Create a table parameter. (Overrides TGIS_DbAbstract.sqlTableCreateParam) |
|
| sqlTableEof | public | Test for Eof on the table. (Overrides TGIS_DbAbstract.sqlTableEof) |
|
| sqlTableExec | public | Execute opened table command. (Overrides TGIS_DbAbstract.sqlTableExec) |
|
| sqlTableGetField | public | Get a field from the table. (Overrides TGIS_DbAbstract.sqlTableGetField) |
|
| sqlTableGetFieldIndex | public | ||
| sqlTableGetParam | public | Get a parameter from the table. (Overrides TGIS_DbAbstract.sqlTableGetParam) |
|
| sqlTableOpenRead | public | Open the table based on provided filter. (Overrides TGIS_DbAbstract.sqlTableOpenRead) |
|
| sqlTableOpenWrite | public | Open the table based on provided filter (Overrides TGIS_DbAbstract.sqlTableOpenWrite) |
|
| sqlTablePost | public | Update the table (after any change). (Overrides TGIS_DbAbstract.sqlTablePost) |
|
| sqlTablePrepare | public | ||
| sqlTablePrepared | public | Is table prepared for insert. (Overrides TGIS_DbAbstract.sqlTablePrepared) |
|
| sqlTableSetBlob | public | Set a blob data to the table. (Overrides TGIS_DbAbstract.sqlTableSetBlob) |
|
| sqlTableSetField | public | Set a field to the table. (Overrides TGIS_DbAbstract.sqlTableSetField) |
|
| sqlTableSetGeometry(Integer; String; OleVariant; TGIS_MemoryStream) | public | Set a geometry to the table. | |
| sqlTableSetGeometry(Integer; String; TObject) | public | Set a geometry to the table. | |
| sqlTransactGlobalUpdateCommit | public | Commit global transaction. (Overrides TGIS_DbAbstract.sqlTransactGlobalUpdateCommit) |
|
| sqlTransactGlobalUpdateStart | public | Start global transaction. (Overrides TGIS_DbAbstract.sqlTransactGlobalUpdateStart) |
|
| sqlTransactRestructCommit | public | Commit transaction. (Overrides TGIS_DbAbstract.sqlTransactRestructCommit) |
|
| sqlTransactRestructStart | public | Start transaction. (Overrides TGIS_DbAbstract.sqlTransactRestructStart) |
|
| sqlTransactRollback | public | Rollback global transaction. (Overrides TGIS_DbAbstract.sqlTransactRollback) |
|
| sqlTransactUpdateCommit | public | Commit transaction. (Overrides TGIS_DbAbstract.sqlTransactUpdateCommit) |
|
| sqlTransactUpdateStart | public | Start transaction. (Overrides TGIS_DbAbstract.sqlTransactUpdateStart) |
|
| sqlUpdateStart | public | Macro for starting updates. (Overrides TGIS_DbAbstract.sqlUpdateStart) |
|
Properties
Inherited
Protected
Private
| Name | Visibility | Description | |
|---|---|---|---|
| CurrentSQLDialect | public | Current SQL dialect name. (Inherited from TGIS_DbAbstract) |
|
| EngineOptions | public | Engine options. (Inherited from TGIS_DbAbstract) |
|
| FullSafeParam | public | if True, prefix with name is returned, otherwise only prefix. (Inherited from TGIS_DbAbstract) |
|
| GeometryType | public | Internal geometry type. (Inherited from TGIS_DbAbstract) |
|
| iCodePage | public | CodePage used for conversion. (Inherited from TGIS_DbAbstract) |
|
| iJoinCodePage | public | JoinCodePage used for conversion. (Inherited from TGIS_DbAbstract) |
|
| InBatchMode | public | True, if batch mode is enabled for fast inserts. (Inherited from TGIS_DbAbstract) |
|
| IsDb2 | public | Is DB2 dialect. (Inherited from TGIS_DbAbstract) |
|
| IsInformix | public | Is Informix dialect. (Inherited from TGIS_DbAbstract) |
|
| IsInterbase | public | Is Interbase dialect. (Inherited from TGIS_DbAbstract) |
|
| IsJDBC | public | if True, JDBC is used. (Inherited from TGIS_DbAbstract) |
|
| IsMsJet | public | Is MsJet dialect. (Inherited from TGIS_DbAbstract) |
|
| IsMsSql | public | Is MsSql dialect. (Inherited from TGIS_DbAbstract) |
|
| IsMySql | public | Is MySql dialect. (Inherited from TGIS_DbAbstract) |
|
| IsOracle | public | Is Oracle dialect. (Inherited from TGIS_DbAbstract) |
|
| IsPostgreSql | public | Is PostgreSQL dialect. (Inherited from TGIS_DbAbstract) |
|
| IsProviderInitialized | public | Is provider initialized. (Inherited from TGIS_DbAbstract) |
|
| IsSqlite | public | Is Sqlite dialect. (Inherited from TGIS_DbAbstract) |
|
| IsSybase | public | Is Sybase dialect. (Inherited from TGIS_DbAbstract) |
|
| MultiUserMode | public | Multiuser mode. (Inherited from TGIS_DbAbstract) |
|
| NameMaxLength | public | Sql name maximum length. (Inherited from TGIS_DbAbstract) |
|
| ParameterPrefix | public | Sql parameter prefix. (Inherited from TGIS_DbAbstract) |
|
| RowsetSize | public | Number of rows fetched in batches from the cursor database (default 0). (Inherited from TGIS_DbAbstract) |
|
| UseTextParameters | public | Use text parameters. (Inherited from TGIS_DbAbstract) |
|
2020/12/24 01:07