[top] [up] [next]

Relational database programming

Trinc-Prolog relational database access is based on the Microsoft Open Database Connectivity (ODBC) interface. The ODBC interface makes it possible for applications to access data from a variety of database management systems. The ODBC interface permits maximum interoperability — an application can access data in diverse database management systems through a single interface. Furthermore, that application can be independent of any database management system from which it accesses data.

  1. Introduction to ODBC and SQL
  2. ODBC architecture
  3. Basic application steps
  4. Statements and transactions
  5. Retrieving results
  6. Date and time formatting
  7. Parameters
  8. Long fields
  9. Stored procedures
  10. Catalog methods
  11. Importing data
  12. Debugging tips
  13. Software requirements
  14. Database classes API reference

[top] [up] [next]

arrow.gif (1632 bytes)New in R3B: new methods to iterate through result sets in a fail driven loop, persistent database connections, more documentation about importing data, stored procedures and the method bindProcedureParameters/2.
 

info@trinc-prolog.com