PowerSql is an add-on library for SQL application development in Xbase++.

PowerSql functions represent abstractions of SQL commands for data access and manipulation. The functions encapsulate most of the options of the SQL commands, which are defined as function parameters. The functions are generalized and automated and perform internally the logic of the SQL commands. You don't need to know SQL programming. Instead, use PowerSql functions as building blocks to create short, fast and efficient programs.

PowerSql library allows applications to access and manipulate data from a variety of database management systems (DBMSs), using ODBC (Open Database Connectivity) interface. ODBC interface permits maximum interoperability - an application can access data from a variety of data sources, both relational (SQL) and non-relational (ISAM), using SQL as a standard for accessing data.

With PowerSql library Xbase++ programmers can create client/server applications using non-file based DBMSs, such as SQL Server, PostgreSQL, MySQL, MariaDB, Oracle, DB2, Informix, SQL Anywhere, Interbase, etc. PowerSql can be also used with file based databases, such as SQLite, Access, Paradox, dBase, Visual FoxPro, etc.

PowerSql library create two types of objects: SQL connection and table. SQL connection object manages connection to an ODBC driver and a data source. The SQL connection must be created before any database operations can be performed.

A table object manages static client side cursor. This object will open the fastest and least expensive (read-only) server side cursor, and open a table in a work area. For fetching data from a data source, PowerSql library creates block cursors which return an array of records in a single fetch. In that way, the network traffic and time for retrieving data are significantly reduced. PowerSql also implements scrollable cursors which can move forward and backward through the data.

PowerSql library supports Alaska Xbase++ V.2.0 to V.1.8.

PowerSql features

Connection - Create ODBC connection.

Data source - Retrieve catalog information: DBMS name, server name, database name, data types, etc.

Database - List database schemas, tables, views, stored procedures and functions.

List table columns, structure, data types, indexes and index keys.

Execute - Execute a single or multiple SQL commands or a stored procedure.

Transaction - Begin, commit and restore transactions.

Table - Open a single or multiple tables in work areas and set relations between them. Open a view on a table.

Retrieve system information of a table and index key.

Move through a table forward and backward.

Seek and locate records in a table.

Retrieve data from a table.

Update - Insert, update and delete records in a table.

Evaluate - Set and execute a code block for a table.