FiveTech Support Forums

FiveWin / Harbour / xBase community
Board index FiveWin for Harbour/xHarbour SQLWIN - a free RDD for SQL
Posts: 44158
Joined: Thu Oct 06, 2005 05:47 PM
SQLWIN - a free RDD for SQL
Posted: Tue Sep 16, 2008 07:47 PM

Vailton,

We have not tested it yet. We will do it in few minutes.

regards, saludos

Antonio Linares
www.fivetechsoft.com
Posts: 44158
Joined: Thu Oct 06, 2005 05:47 PM
SQLWIN - a free RDD for SQL
Posted: Wed Sep 17, 2008 12:03 AM

Vailton,

We have tested it with Harbour and had to make some changes.

Still there is an error in line:
cSQL += " WHERE " + cRddSep + FLD_RECNO + cRddSep + " = " + AllTrim( Str( RecNo() ) )

RecNo() seems to be nil with Harbour.

It should be better and faster to test it, if we have everything -for now- in the same PRG.

regards, saludos

Antonio Linares
www.fivetechsoft.com
Posts: 44158
Joined: Thu Oct 06, 2005 05:47 PM
SQLWIN - a free RDD for SQL
Posted: Wed Sep 17, 2008 12:06 AM

The most recent version (the same that there is in the wiki) is here:

www.fivetechsoft.com/files/sqlwin.zip

http://wiki.fivetechsoft.com/doku.php?i ... evelopment

regards, saludos

Antonio Linares
www.fivetechsoft.com
Posts: 47
Joined: Thu Jan 05, 2006 06:56 PM
SQLWIN - a free RDD for SQL
Posted: Wed Sep 17, 2008 12:44 AM

Creio que o correto é puxarmos o valor de RECNO() diretamente do campo SQL_RECNO, evitando processamento adicional e desnecessário...

Vailton Renato
Posts: 782
Joined: Wed Dec 19, 2007 07:50 AM
SQLWIN - a free RDD for SQL
Posted: Wed Sep 17, 2008 09:06 AM

Hi Antonio:

For people not to get lost keeping track of sqlwin.prg program logic through your msginfo's, why not to put the code line number as a part of second parameter in each msginfo call ?

I could do it but don't know the wiki's operation.

Best regards.

Manuel Mercado

manuelmercado at prodigy dot net dot mx
Posts: 44158
Joined: Thu Oct 06, 2005 05:47 PM
SQLWIN - a free RDD for SQL
Posted: Wed Sep 17, 2008 10:24 AM

Dear Manuel,

We provide you write access to the wiki so you can modify it yourself and help us :-)

Your suggestion seems very interesting, thanks!

You will receive an email in some minutes with your login and password for the wiki.

regards, saludos

Antonio Linares
www.fivetechsoft.com
Posts: 782
Joined: Wed Dec 19, 2007 07:50 AM
SQLWIN - a free RDD for SQL
Posted: Wed Sep 17, 2008 11:47 AM
Antonio Linares wrote:It should be better and faster to test it, if we have everything -for now- in the same PRG.
Hi Antonio, Vailton:

I aggree with Antonio, at least for this first step, otherwise we have to provide batch or make builders for each compiler.

Regards.

Manuel Mercado
manuelmercado at prodigy dot net dot mx
Posts: 44158
Joined: Thu Oct 06, 2005 05:47 PM
SQLWIN - a free RDD for SQL
Posted: Wed Sep 17, 2008 02:02 PM

I had the pleasure to have a live session with Manuel Mercado, using TeamViewer, and now he has already started cooperating in the wiki.

Thanks Manuel! :-)

http://wiki.fivetechsoft.com/doku.php?d ... evelopment

regards, saludos

Antonio Linares
www.fivetechsoft.com
Posts: 47
Joined: Thu Jan 05, 2006 06:56 PM
SQLWIN - a free RDD for SQL
Posted: Wed Sep 17, 2008 05:24 PM
Antonio for debug purposes only, it would be safer to use a #COMMAND for this? What do you think of something:

#command TRACE <x>    =>    MsgInfo( <x>, ProcName(0) + "(" + LTrim( Str( ProcLine( 0 ) ) ) + ")" )

or something like:
#command TRACE [ <list,...> ] => MsgInfo( valToPrg(<list>), ProcName(0) + "(" + LTrim( Str( ProcLine( 0 ) ) ) + ")" )

:-)
Vailton Renato
Posts: 44158
Joined: Thu Oct 06, 2005 05:47 PM
SQLWIN - a free RDD for SQL
Posted: Wed Sep 17, 2008 06:23 PM

Vailton,

Yes, good idea :-)

regards, saludos

Antonio Linares
www.fivetechsoft.com
Posts: 782
Joined: Wed Dec 19, 2007 07:50 AM
SQLWIN - a free RDD for SQL
Posted: Wed Sep 17, 2008 06:42 PM
Antonio Linares wrote:I had the pleasure to have a live session with Manuel Mercado, using TeamViewer, and now he has already started cooperating in the wiki.
Hi Antonio:

No sé como se dice en inglés "Al que le urge, atiza el fogón" :-)

Ok, we have now separated the test program and the rdd SqlWin program, I have published a command line batch builder for Harbour and xHarbour.

With xHarbour everything seems to be ok, but have some problems with Harbour, please take a look.

Regards.

Manuel Mercado
manuelmercado at prodigy dot net dot mx
Posts: 47
Joined: Thu Jan 05, 2006 06:56 PM
SQLWIN - a free RDD for SQL
Posted: Wed Sep 17, 2008 06:49 PM

From today until Friday I'm working on a internal project. I will not have time for this project, but hope to complete shortly the SKIPRAW() implementation.

Vailton Renato
Posts: 44158
Joined: Thu Oct 06, 2005 05:47 PM
SQLWIN - a free RDD for SQL
Posted: Wed Sep 17, 2008 07:54 PM

Vailton,

Thanks! :-)

regards, saludos

Antonio Linares
www.fivetechsoft.com
Posts: 116
Joined: Thu Oct 13, 2005 05:14 PM
SQLWIN - a free RDD for SQL
Posted: Thu Sep 18, 2008 06:23 AM

What about this RDD performance compared to ADSRDD?

I guess simulating ISAM logic with SQL statements make the performance very low to use in real world huge applications.

Regards,
Roberto Parisi

Posts: 44158
Joined: Thu Oct 06, 2005 05:47 PM
SQLWIN - a free RDD for SQL
Posted: Thu Sep 18, 2008 06:38 AM

Roberto,

We have not tested it yet with real connections, so we don't know how fast it will be yet :-)

regards, saludos

Antonio Linares
www.fivetechsoft.com