Something about SQL

[Enrico Maria Giordano]

Dear friends, I was asked to port a big application to SQL with the minimun effort.

Any suggestion is welcome.

EMG

[Antonio Linares]

Enrico,

I guess that the simplest solution is to use SQLRDD (commercial).

If you have enough time, then I would suggest to use SQLWIN, as you have full source code and its implementation is quite similar to SQLRDD. SQLWIN is a work in progress, but already offers enough functionality. SQLWIN is open source and free:

http://wiki.fivetechsoft.com/doku.php?id=sqlwin_development

[Enrico Maria Giordano]

Enrico,

I guess that the simplest solution is to use SQLRDD (commercial).

I tried SQLRDD more than once in the past but it never worked correctly. I reported the bugs but never got a response. So I gave up to use it.

If you have enough time, then I would suggest to use SQLWIN, as you have full source code and its implementation is quite similar to SQLRDD. SQLWIN is a work in progress, but already offers enough functionality. SQLWIN is open source and free:

http://wiki.fivetechsoft.com/doku.php?id=sqlwin_development

Thank you. Is there a link from where it can be downloaded?

EMG

[Antonio Linares]

Enrico,

You have to copy and paste it from here:
http://wiki.fivetechsoft.com/doku.php?id=sqlwin_development

We could start a project in google code and upload the files to download, examples, etc

I always thought that SQLWIN is the way to go, as a free and open source replacement for SQLRDD and similars (that are completely closed).

[Antonio Linares]

Already created

https://code.google.com/p/sqlwin/

[Enrico Maria Giordano]

Thank you!

EMG

[Enrico Maria Giordano]

Sorry, I don't understand how to use it...

EMG

[Antonio Linares]

Enrico,

Here you have an example of use:

https://code.google.com/p/sqlwin/downloads/detail?name=postgres.prg

[Antonio Linares]

And here the instructions to build it with Harbour and xHarbour:

https://code.google.com/p/sqlwin/w/list

[Enrico Maria Giordano]

Thank you. I will try it and report back.

EMG

[Antonio Linares]

Enrico,

It seems as Rossine uploaded a SQLWIN more recent version to our wiki but mainly based on Postgress.

I am going to look for the previous version (without Postgress) and I will upload it to the project site and I will report it here, also with some simple examples

[Enrico Maria Giordano]

Thank you, Master!

EMG

[Marc Vanzegbroeck]

Enrico,

I'am surpriced that you don't use ADO with SQL.

I have already converted some of my project to MYSQL with ADO and SQLite with ADO, and I'm very happy with it.
It's because of you and Rick Lipkin that I have switched to ADO.
http://forums.fivetechsupport.com/viewtopic.php?f=3&t=24920&hilit=sql

I also use recordsets like you also suggested in an other topic.

My programs are much faster an most of the time I need less code
There was even a case that I use to have more than 10 lines, and now I have only 3 lines to do the same (and faster)

[Enrico Maria Giordano]

Marc,

I use ADO for the new SQL project. But now I need to port a big DBF application to SQL and cannot afford the huge work that would be required to rewrite the application using ADO.

EMG

[ADutheil]

When I began to migrate my system to SQL I used Mediator: http://www.otc.pl I found it easy to use.