Commands and Topics for 4D For PostgreSQL

4D For PostgreSQL, Command Alphabetical List

Preface
PGSQL_Connect (host ; port; options; tty; database; user; password) Longint
PGSQL_Close (connID)
PGSQL_Execute (connID; sqlQuery) Longint
PGSQL_GetFieldCount (resID; fieldCount) Longint
PGSQL_GetFieldName (resID; fieldIndex; fieldName) Longint
PGSQL_GetRowCount (resID; rowCount) Longint
PGSQL_GetFieldIndex (resID; fieldName; fieldIndex) Longint
PGSQL_GetFieldType (resID; fieldIndex; fieldType) Longint
PGSQL_GetFieldMod (resID; fieldIndex; fieldMod) Longint
PGSQL_GetFieldSize (resID; fieldIndex; fieldSize) Longint
PGSQL_IsBinaryTuples (resID; isBinary) Longint
PGSQL_IsFieldDataNull (resID; rowIndex; fieldIndex; isNull) Longint
PGSQL_GetFieldLength (resID; rowIndex; fieldIndex; fieldLength) Longint
PGSQL_GetStringValue (resID; rowIndex; fieldIndex; stringValue) Longint
PGSQL_GetIntegerValue (resID; rowIndex; fieldIndex; integerValue) Longint
PGSQL_GetLongintValue (resID; rowIndex; fieldIndex; longintValue) Longint
PGSQL_GetRealValue (resID; rowIndex; fieldIndex; realValue) Longint
PGSQL_GetDateValue (resID; rowIndex; fieldIndex; dateValue) Longint
PGSQL_GetTimeValue (resID; rowIndex; fieldIndex; hourValue; minValue; secValue) Longint
PGSQL_GetTextValue (resID; rowIndex; fieldIndex; textValue) Longint
PGSQL_GetBooleanValue (resID; rowIndex; fieldIndex; booleanValue) Longint
PGSQL_GetAffectedRows (resID; affectedRows) Longint
PGSQL_GetLastCmdStatus (resID; lastCmdStatus) Longint
PGSQL_GetResultStatus (resID; resultStatus) Longint
PGSQL_GetResultErrorMess (resID; errorMess) Longint
PGSQL_CloseResult (resID)
PGSQL_ResetConn (connID)
PGSQL_GetDbName (connID; dbName) Longint
PGSQL_GetUserName (connID; userName) Longint
PGSQL_GetPassword (connID; password) Longint
PGSQL_GetHostname (connID; hostName) Longint
PGSQL_GetPortNum (connID; portNum) Longint
PGSQL_GetOptions (connID; options) Longint
PGSQL_GetConnStatus (connID) Longint
PGSQL_GetLastConnError (connID) Longint
PGSQL_GetOIDValue (resID; fieldIndex; rowIndex; objectValue) Longint
PGSQL_GetByteaValue (resID; fieldIndex; rowIndex; byteaValue) Longint
PGSQL_EscapeBytea (byteaToEscape; escapedBytea)
PGSQL_UnescapeBytea (byteaToUnescape; unescapedBytea)
PGSQL_CreateLOB (connID; mode) Longint
PGSQL_ImportLOB (connID; filePath; objectID) Longint
PGSQL_ExportLOB (connID; filePath; objectID) Longint
PGSQL_GetLOBData (connID; objectID; lobData) Longint
PGSQL_SetLOBData (connID; objectID; lobData) Longint
PGSQL_RemoveLOB (connID; objectID) Longint
PGSQL_Register (serialNum) Longint
PGSQL_ExecuteWithBlob (connID; blobedQuery) Longint
PGSQL_GetValues (resID; fieldIndex; columnArray; startRow; rowCount)