Xbase++ programming tools
PowerSql library

PowerXpp, PowerSql, PowerCom, PowerWeb, DBM, DBA Windows

PowerSql is an add-on library for SQL application development in Xbase++. PowerSql library implements top-down modular style of programming. It is function-oriented because functions are more comfortable for writing programs than commands, and programs are shorter and faster. The functions and theirs arguments are very flexible, user-friendly, intuitive, simple and easy to use.

PowerSql functions represent the object abstractions of SQL commands for data access and manipulation. The functions encapsulate the most of the elements of SQL commands, that are defined as function arguments. The functions are generalized and automated and perform internally the SQL commands logic. You don't need to know SQL programming, just 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 Xbase++ 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 librray can create two types of objects: connection and data set. SQL connection object manages SQL connection to an ODBC driver and a data source. ADO connection object manages ADO 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 can be used both in desktop and web applications. It can be used standalone and independently of the other members of Power family libraries or together with them.

PowerSql library requires Alaska Xbase++ version 1.9 or higher. 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.

You can order PowerSql library on the Order page.

PowerSql Library Features
Connection Create ODBC and ADO connection.

Xbase++ programming tools - PowerSql library - Conn1

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

Xbase++ programming tools - PowerSql library - Conn2

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

Xbase++ programming tools - PowerSql library - Conn3

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

Xbase++ programming tools - PowerSql library - Conn4 Xbase++ programming tools - PowerSql library - Conn5

Execute Execute a single or multiple SQL commands or stored procedure.
Transactions Begin, commit and restore transactions.
Data set use Open a single or multiple tables, create data sets and set relations between them.

Xbase++ programming tools - PowerSql library - DSet1

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

Xbase++ programming tools - PowerSql library - DSet2 Xbase++ programming tools - PowerSql library - DSet3

Data set move Move through a data set forward and backward.
Data set find Seek and locate a record 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.
Data set query Refresh and index data set.