• xHarbour Builder
• Visual xHarbour
• Add-ons

Add-on overview » xHarbour SQLRDD + SQLEX » more info about SQLEX

The new SQLRDD Extreme Edition (SQLEX) from xHarbour.com 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. We experienced a performance improvement in SKIP, SEEK, APPEND, etc., from 5 to 15 times (depending on database system)! But of course your app will not get 10 times faster just by replacing RDD, because it is not coded only by DML commands. You also use many other commands and functions that are not related with RDD or data access. Not right now. At this time, SQLEX connects through ODBC (or UnixODBC) to any database. So if native access is a requirement to your application, you still will use SQLRDD. But we plan to start adding native access to SQLEX in next releases. The SQLEX RDD lib is shipped in the same sql.lib (or sql.a in Linux) file as well as SQLRDD. 1 - Add to the top of your main PRG: REQUEST SQLEX
2 - Open your tables VIA SQLEX instead of VIA SQLRDD
3 - SQLEX connects to database only through ODBC, so you should setup an ODBC DSN in order to use it. Connection routines are exactly the same from SQLRDD. SQLEX at this stage supports only ODBC connections to following databases (please observe database version):

• MSSQL Server 2000 or 2005
• Postgres 9.0
• Firebird 2.1
• MySQL 5.1
• Oracle 9i and 10g The latest ODBC driver version 5.1.5 from MySQL.org is completely broken and may cause unexpected results. You should use ODBC driver version 3.51 that can be downloaded from following link: http://dev.mysql.com/downloads/connector/odbc/3.51.html#win32

I also get errors in logical fields in Postgres. What's wrong ?
When creating the ODBC DSN, Postgres driver automatically sets the option "Boolean as Char". You should uncheck this option in ODBC setup. If you create the DSN from source code using SR_InstallDSN() function, you can fix this option by adding "BoolsAsChar=0;" in parameter list. No. SQLEX will be a free upgrade to all Enterprise and SQLRDD users with active Update & Service Subscription at xharbour.com. SQLRDD + SQLEX is included in every xHarbour Builder Enterprise edition.

If you have a xHarbour Builder professional edition, please click here to go directly to the order page.
As free.xHarbour.com uses the same sources as xHarbour.org binaries, yes, SQLRDD and the new SQLEX are also available for free.xHarbour.com binaries. If you like to purchase SQLRDD and SQLEX for free.xHarbour.com, you need the "SQLRDD + SQLEX for xHarbour.org" package xHarbour.com's shop.

SQLRDD + SQLEX for xHarbour.org is only $595.00 and can be purchased from here.