SQLWIN - a free RDD for SQL

Postby Antonio Linares » Tue Sep 16, 2008 7:47 pm

Vailton,

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

Antonio Linares
www.fivetechsoft.com
User avatar
Antonio Linares
Site Admin
 
Posts: 42122
Joined: Thu Oct 06, 2005 5:47 pm
Location: Spain

Postby 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.
regards, saludos

Antonio Linares
www.fivetechsoft.com
User avatar
Antonio Linares
Site Admin
 
Posts: 42122
Joined: Thu Oct 06, 2005 5:47 pm
Location: Spain

Postby 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
regards, saludos

Antonio Linares
www.fivetechsoft.com
User avatar
Antonio Linares
Site Admin
 
Posts: 42122
Joined: Thu Oct 06, 2005 5:47 pm
Location: Spain

Postby 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...
Vailton Renato
User avatar
vailtom
 
Posts: 47
Joined: Thu Jan 05, 2006 6:56 pm

Postby 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
User avatar
mmercado
 
Posts: 782
Joined: Wed Dec 19, 2007 7:50 am
Location: Salamanca, Gto., México

Postby 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.
regards, saludos

Antonio Linares
www.fivetechsoft.com
User avatar
Antonio Linares
Site Admin
 
Posts: 42122
Joined: Thu Oct 06, 2005 5:47 pm
Location: Spain

Postby 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
User avatar
mmercado
 
Posts: 782
Joined: Wed Dec 19, 2007 7:50 am
Location: Salamanca, Gto., México

Postby 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
regards, saludos

Antonio Linares
www.fivetechsoft.com
User avatar
Antonio Linares
Site Admin
 
Posts: 42122
Joined: Thu Oct 06, 2005 5:47 pm
Location: Spain

Postby 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  Expand view  RUN
#command TRACE <x>    =>    MsgInfo( <x>, ProcName(0) + "(" + LTrim( Str( ProcLine( 0 ) ) ) + ")" )

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

:?:
Vailton Renato
User avatar
vailtom
 
Posts: 47
Joined: Thu Jan 05, 2006 6:56 pm

Postby Antonio Linares » Wed Sep 17, 2008 6:23 pm

Vailton,

Yes, good idea :-)
regards, saludos

Antonio Linares
www.fivetechsoft.com
User avatar
Antonio Linares
Site Admin
 
Posts: 42122
Joined: Thu Oct 06, 2005 5:47 pm
Location: Spain

Postby 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" :D

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
User avatar
mmercado
 
Posts: 782
Joined: Wed Dec 19, 2007 7:50 am
Location: Salamanca, Gto., México

Postby 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.
Vailton Renato
User avatar
vailtom
 
Posts: 47
Joined: Thu Jan 05, 2006 6:56 pm

Postby Antonio Linares » Wed Sep 17, 2008 7:54 pm

Vailton,

Thanks! :-)
regards, saludos

Antonio Linares
www.fivetechsoft.com
User avatar
Antonio Linares
Site Admin
 
Posts: 42122
Joined: Thu Oct 06, 2005 5:47 pm
Location: Spain

Postby 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
Roberto Parisi
 
Posts: 116
Joined: Thu Oct 13, 2005 5:14 pm
Location: Italy

Postby 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 :-)
regards, saludos

Antonio Linares
www.fivetechsoft.com
User avatar
Antonio Linares
Site Admin
 
Posts: 42122
Joined: Thu Oct 06, 2005 5:47 pm
Location: Spain

PreviousNext

Return to FiveWin for Harbour/xHarbour

Who is online

Users browsing this forum: Google [Bot] and 42 guests