XbPgSQL


*Where this package relies on other packages, the additional packages are listed below it.

Author(s) Phil Ide
Packages  Description
  • XbPgSQL  
  • piCommon.ch  
  • High Resolution Timer  
  • This is a pair of classes for using PostGreSQL from Xbase++
    • PGSql()
      This handles connections and server or connection specific info
    • PGResult()
      This handles results, traverses tuples etc.

    These classes use libpq.dll (supplied) to connect to the server, and this is waaaaay faster than using ODBC.

    If you don't want to use the high-resoluion timer, you can remove it easily from the source.

    Update History
    Version Updated Description
    1.2 18.03.2005 Fix for PGSql:execParams() method
    1.1 06.10.2004 Fix to a couple of PGResult() methods not dereferencing the returned pointer
    1.0 09.02.2004 Added:
    • PQescapeString
    • PQescapeBytea
    • PQunescapeBytea
    • PQmakeEmptyPGResult
    • PQsetnonblocking
    • PQisnonblocking
    • PQsendQuery
    • PQgetResult
    • PQconsumeInput
    • PQisBusy
    • PQflush
    • PQsocket
    • PQrequestancel
    • PQtrace
    • PQuntrace
    Completed initial implementation, set version to 1.0
    0.4 06.02.2004 Added:
    • PQsetdbLogin
    • PQconnectStart
    • PQconnectPoll
    • PQresetStart
    • PQresetPoll
    • PQresultStatus
    • PQresStatus
    • PQmakeEmptyPGResult
    • PQescapeString
    • PQescapeBytea
    • PQunescapeBytea
    • PQfmod
    • PQbinaryTuples
    Also added some parsing features to the sample app.
    0.3 03.02.2004 Added position(), goToPosition(), recno() methods
    Added myPGSQLBrowse() class
    0.2 03.02.2004 Added Skip(), GoTop(), GoBottom(), GoTo() methods
    Also added ability to dynamically handle fields as virtual iVars
    0.1 02.02.2004 First public beta