SQLWIN - a free RDD for SQL

Post by **Antonio Linares** » Tue Sep 16, 2008 7:47 pm

Vailton,

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

Post by **Antonio Linares** » 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.

Post by **Antonio Linares** » 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

vailtom · Post by **vailtom** » 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...

mmercado · Post by **mmercado** » Wed Sep 17, 2008 9: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

Post by **Antonio Linares** » 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.

mmercado · Post by **mmercado** » 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

Post by **Antonio Linares** » Wed Sep 17, 2008 2: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

vailtom · Post by **vailtom** » Wed Sep 17, 2008 5:24 pm

Antonio for debug purposes only, it would be safer to use a #COMMAND for this? What do you think of something:

Code: Select all

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

or something like:

Code: Select all

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

Post by **Antonio Linares** » Wed Sep 17, 2008 6:23 pm

Vailton,

Yes, good idea

mmercado · Post by **mmercado** » Wed Sep 17, 2008 6: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

vailtom · Post by **vailtom** » Wed Sep 17, 2008 6: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.

Post by **Antonio Linares** » Wed Sep 17, 2008 7:54 pm

Vailton,

Thanks!

Roberto Parisi · Post by **Roberto Parisi** » Thu Sep 18, 2008 6: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

Post by **Antonio Linares** » Thu Sep 18, 2008 6:38 am

Roberto,

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