Page 1 of 3

Something about SQL

PostPosted: Wed Apr 17, 2013 7:41 pm
by Enrico Maria Giordano
Dear friends, I was asked to port a big application to SQL with the minimun effort.

Any suggestion is welcome. :-)

EMG

Re: Something about SQL

PostPosted: Wed Apr 17, 2013 8:21 pm
by 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

Re: Something about SQL

PostPosted: Wed Apr 17, 2013 8:45 pm
by Enrico Maria Giordano
Antonio Linares wrote: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.

Antonio Linares wrote: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

Re: Something about SQL

PostPosted: Wed Apr 17, 2013 9:00 pm
by 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).

Re: Something about SQL

PostPosted: Wed Apr 17, 2013 9:04 pm
by Antonio Linares

Re: Something about SQL

PostPosted: Wed Apr 17, 2013 9:22 pm
by Enrico Maria Giordano
Thank you! :-)

EMG

Re: Something about SQL

PostPosted: Wed Apr 17, 2013 9:24 pm
by Enrico Maria Giordano
Sorry, I don't understand how to use it... :-(

EMG

Re: Something about SQL

PostPosted: Wed Apr 17, 2013 9:39 pm
by Antonio Linares

Re: Something about SQL

PostPosted: Wed Apr 17, 2013 9:42 pm
by Antonio Linares
And here the instructions to build it with Harbour and xHarbour:

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

Re: Something about SQL

PostPosted: Thu Apr 18, 2013 9:21 am
by Enrico Maria Giordano
Thank you. I will try it and report back.

EMG

Re: Something about SQL

PostPosted: Thu Apr 18, 2013 10:47 am
by 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 :-)

Re: Something about SQL

PostPosted: Thu Apr 18, 2013 11:18 am
by Enrico Maria Giordano
Thank you, Master! :-)

EMG

Re: Something about SQL

PostPosted: Thu Apr 18, 2013 11:26 am
by Marc Vanzegbroeck
Enrico,

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

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) :D

Re: Something about SQL

PostPosted: Thu Apr 18, 2013 11:33 am
by 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

Re: Something about SQL

PostPosted: Thu Apr 18, 2013 11:50 am
by ADutheil
When I began to migrate my system to SQL I used Mediator: http://www.otc.pl I found it easy to use.