PowerSql is an add-on library for SQL application development in Xbase++. PowerSql library is function-oriented and implements top-down modular style of programming. Functions and their parameters are very flexible, user-friendly, intuitive and easy to use.

PowerSql functions represent object abstractions of SQL commands for data access and manipulation. The functions encapsulate most of the elements of SQL commands, which are defined as function parameters. The functions are generalized and automated and perform the complete logic of SQL commands. You don't need to know SQL programming. Instead, use PowerSql functions as building blocks to create fast and efficient programs with a minimum number of code lines and that use the minimum amount of memory resources.

PowerSql library allows applications to access and manipulate data from a variety of database management systems (DBMSs), using ODBC (Open Database Connectivity) interface or ADO (ActiveX Data Objects) interface through an OLE DB provider. Both interfaces permit 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. Furthermore, the application will be independent of any DBMS from which it accesses data. Users of the application can add software components called drivers, that interface between an application and a specific DBMS.

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 library can be also used with file based databases, such as SQLite, Access, Paradox, dBase, Visual FoxPro, etc.

PowerSql library create two types of objects: connection and data set. ODBC connection object manages connection to an ODBC driver and a data source. ADO connection object manages connection to an OLE DB provider and a data source. An ODBC or ADO connection must be created before any database operations can be performed.

A data set object manages static client side cursor. This object will open the fastest and least expensive (read-only, forward) server side cursor, retrieve the entire record set into memory and then close the server side cursor in order to reduce server resources. Once the record set is retrieved, the data set object provides very fast, forward and backward scrolling through itself and allows relations to be created to other data sets that may be connected to different data sources.

PowerSql library contains multiple modules listed in the following table.

Module	Description
PowerSqlOdbc	ODBC connection
PowerSqlAdo	ADO connection
PowerSqlData	Data set

PowerSql library supports Alaska Xbase++ V.2.0 to V.1.8. It is available in Serbian and English language, but can be easy modified by the user in any language.

Demo program of PowerSql library with complete documentation and examples can be downloaded on the Download page.

PowerSql Library Features
PowerSqlOdbc/PowerSqlAdo Module
Connection	Create ODBC and ADO 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.
Table	List table columns, structure, data types, indexes and index keys.
Execute	Execute a single or multiple SQL commands or stored procedure.
Transaction	Begin, commit and restore transactions.
PowerSqlData Module
Data set use	Open a single or multiple tables, create data sets and set relations between them.
Data set info	Retrieve system information of a data set and index key.
Data set move	Move through a data set forward and backward.
Data set find	Seek and locate records in a data set.
Data set get	Retrieve fields, records, columns or arbitrary data from a data set.
Data set update	Insert, update and delete records in a data set and table.
Data set evaluate	Set and execute a code block in a data set.