SQLWIN - a free RDD for SQL

Post by **Antonio Linares** » Wed Sep 10, 2008 4:57 am

We start the development of SQLWIN, a free and open source RDD for SQL.

All of you interested in learning and use SQL are welcome to join this project. You can already download a very early prototype, but that can be already compiled and tested:

www.fivetechsoft.com/files/sqlwin.zip

The source code is licenced with the same Harbour licence (not included yet in its code). We start from the ADORDD source code, but just to use its structure, that will be totally redesigned.

Please visit also the spanish thread where some developers have already joined the project:

http://forums.fivetechsoft.com/viewtopic.php?t=12645

Post by **Antonio Linares** » Wed Sep 10, 2008 5:00 am

At this stage we are not making a real connection yet.

We are focused to translate all the RDD Db...() functions into their equivalent SQL sentences.

On a next step we will create real connections to the database engines. By now, we are using a "virtual" DBF for testing purposes.

Post by **Antonio Linares** » Wed Sep 10, 2008 5:50 am

New version that implements the emulated values "sql_recno" and "sql_deleted", and a first DbGoTop() version:

www.fivetechsoft.com/files/sqlwin.zip

Post by **Antonio Linares** » Wed Sep 10, 2008 6:36 am

New version that implements DbGoTo():

www.fivetechsoft.com/files/sqlwin.zip

Post by **Antonio Linares** » Wed Sep 10, 2008 6:53 am

New version that implements RecNo() and RecCount():

www.fivetechsoft.com/files/sqlwin.zip

Roberto Parisi · Post by **Roberto Parisi** » Wed Sep 10, 2008 6:58 am

Hi Antonio,
what's the difference with adordd?

Regards,
Roberto Parisi

Post by **Antonio Linares** » Wed Sep 10, 2008 7:06 am

Roberto,

ADORDD is based on Microsoft ADO, and if has the limitations imposed by ADO.

SQLWIN is based on SQL that will be executed against different database engines or through ODBC, and it does not use ADO.

We have found that ADO imposes restrictions to mimic a full working RDD, in the sense that you may replace DBFCDX or DBFNTX with ADORDD and just recompile your app, with very few changes (database string connection info).

Using SQL we may be able to bypass those restrictions and implement a complete RDD, that may be able to replace DBFCDX or DBFNTX.

Roberto Parisi · Post by **Roberto Parisi** » Wed Sep 10, 2008 7:13 am

Thx Antonio,
it looks quite interesting.

What are the target databases?

Regards,
Roberto Parisi

Post by **Antonio Linares** » Wed Sep 10, 2008 7:21 am

Roberto,

> What are the target databases?

We may start with the most widely used ones like MySQL, MS SQL, Oracle, Informix, etc.

But our idea is to support as much of them as possible

Post by **Antonio Linares** » Wed Sep 10, 2008 7:32 am

New version that implements PACK command (__DbPack()):

www.fivetechsoft.com/files/sqlwin.zip

Post by **Antonio Linares** » Wed Sep 10, 2008 7:40 am

New version that implements ZAP command (__DbZap()):

www.fivetechsoft.com/files/sqlwin.zip

Rossine · Post by **Rossine** » Wed Sep 10, 2008 9:31 pm

Olá Antonio,

Seria possível fazer esta classe funcionar com firebird ou postgres ?

Obrigado e parabéns pela iniciativa

Rossine.

Post by **Antonio Linares** » Thu Sep 11, 2008 1:24 pm

Rossine,

> Seria possível fazer esta classe funcionar com firebird ou postgres ?

Si, claro que si. Podemas hacer que funcione con cualquier motor de bases de datos que soporte SQL

.

Yes, of course. We can make it make it work with any database engine that supports SQL

Post by **Antonio Linares** » Thu Sep 11, 2008 1:27 pm

New version that modifies the sql_recno as NOT NULL, AUTO_INCREMENTAL and UNIQUE. Also some changes for sql_deleted NOT NULL. More cleaned code and tested with Harbour and xHarbour:

www.fivetechsoft.com/files/sqlwin.zip

vailtom · Post by **vailtom** » Fri Sep 12, 2008 4:26 pm

Hi Antonio!

This RDD is designed only for FiveWin? You want to run this RDD on Linux too?

Sorry for my bad english!