• xHarbour Builder
• Visual xHarbour
• Add-ons

Add-on overview » xHarbour SQLRDD + SQLEX

SQLRDD was created to access SQL database servers like Oracle, Microsoft SQL Server, IBM DB/2, Postgres, Sybase, MySQL, Firebird and others, from xHarbour xBase language just like you are used to use DBFCDX or any other regular xBase database driver.

SQLRDD is not just SQL access. It's a complete toolset for quick migration of your complete application to any major SQL database, adding transactional control, database level constraints, etc., as well as direct SQL access.

The new SQLRDD Extreme Edition (SQLEX) is the result of an extensive investment in development, where we put together all the experience acquired in more than 14 years dealing with DBF/SQL dilemma and addressing the needs of hundreds of users worldwide. SQLEX is not a common SQLRDD rewrite.

We're introducing a completely new approach to access a "result set based architecture" (SQL) from a "xBase DML", and it is 100% coded in C language. Since we first released SQLRDD, the main concern of our users is performance. And that's exactly what's we're improving in this new product; SQLEX.

SQLRDD is more than a RDD. It is a complete suite to interact with SQL databases from within xHarbour compiler and most importantly, SQLRDD is Royal-free.

The SQLRDD is a component of xHarbour Builder Enterprise that allows transparent access to the most important relationary data bases of the market, accurately in the same way as if it makes with archives DBF.

Available documentation can be reviewed on xHDN.

• Very little changes in the xBase source code. Only to declare the RDD, a function call to connect to the database and a substitution for the function file() for an equivalent that returns the presence of the internal archive of the database;
• It supports all the traditional commands of the Clipper/xHarbour, such as USE, APPEND FROM, SEEK, dbRLock(), dbUnlock(), dbCommit(), ZAP, REPLACE, etc.
• It supports commands of table creation and indices like dbCreate(), OrdCreate(), INDEX ON ..., etc.
• It supports all the functionalities of CDX indices like order bags and tags.
• It supports the index expressions with proper user functions.
• Simultaneous access to multiple databases without change in the xBase code.
• Transaction Control, allows rollback on changes
• Royalty-free: this means that you do not need to pay a fee when distributing applications with SQLRDD.
• Same source code runs in both WIndows and Linux
• It does not need a module installed in the Server.
• Integrity of data supplied by the SQL database guaranteed. This means no more re-indexing!

Below is an overview of the databases currently supported by SQLRDD. Please note that new databases can and will be added in the future.

Database	Unix ODBC	ODBC	Native Access
Oracle 8, 9	OK	OK	OK
MS SQL Server 7, 2000	OK	OK	/
DB2, DB2/400, DB2/6000	OK	OK	/
Postgres 7.3 to 9.0	OK	OK	OK
Caché	OK	OK	/
MySQL 4.1	OK	OK	OK
Firebird/Interbase	OK	OK	OK
Sybase System XI, XI	OK	OK	/
CA-Ingres R3	OK	OK	/
ADABAS-D	OK	OK	/