FiveTech Support Forums

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

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.

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

www.fivetechsoft.com/files/sqlwin.zip

New version that implements DbGoTo():

www.fivetechsoft.com/files/sqlwin.zip

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

www.fivetechsoft.com/files/sqlwin.zip

Hi Antonio,
what's the difference with adordd?

Regards,
Roberto Parisi

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.

Thx Antonio,
it looks quite interesting.

What are the target databases?

Regards,
Roberto Parisi

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

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

www.fivetechsoft.com/files/sqlwin.zip

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

www.fivetechsoft.com/files/sqlwin.zip

Olá Antonio,

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

Obrigado e parabéns pela iniciativa

Rossine.

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

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

Hi Antonio!

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

Sorry for my bad english!