PowerSql library

PowerWin, PowerSql, PowerCom, PowerWeb, PowerCrp, PowerUtl, DBM, DBA Windows

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.

Xbase++ programming tools - PowerSql library - Con1

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

Xbase++ programming tools - PowerSql library - Con2

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

Xbase++ programming tools - PowerSql library - Con3

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

Xbase++ programming tools - PowerSql library - Con4 Xbase++ programming tools - PowerSql library - Con5

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.

Xbase++ programming tools - PowerSql library - Data1

Data set info Retrieve system information of a data set and index key.

Xbase++ programming tools - PowerSql library - Data2 Xbase++ programming tools - PowerSql library - Data3

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.