SQLWIN - a free RDD for SQL

vailtom · Post by **vailtom** » Sat Sep 13, 2008 6:37 pm

I want to finish on next Tuesday the routines of SEEK / INDEX.

vailtom · Post by **vailtom** » Mon Sep 15, 2008 10:59 pm

Antonio noticed that the queries used in these examples are formatted for MySQL, I correct?

Post by **Antonio Linares** » Mon Sep 15, 2008 11:07 pm

Vailton,

Yes, mostly.

Dear Vailton, please change that "red brain" avatar. It hurts

vailtom · Post by **vailtom** » Tue Sep 16, 2008 4:11 pm

Hi Antonio!

I was devoting time to a SQLWin and made some changes that I would like to submit:

Code: Select all

* Noted that it is necessary to allocate some default values for items of aWAData [] to avoid errors with NIL values such as a APPEND BLANK be called before a RecCount (). I adjusted it. 
   
* Created in some drivers to control the possible SQL in use. 
   
* GetFieldNames () / GetFieldEmptyValues () now receives an additional parameter to detect the type of driver in use and format the return correctly. 
   
* New function SQLGetFullTableName () which returns the name of the table with his SCHEMA inside the database. 

* Created the function SQLAdjustFn () which formats the file name passed as argument to a valid name in the database. Ideal for use in CREATE, USE, COPY, etc. .. 
    
* GoBottom implementation 
* Transaction Counter 
   
* Introduced a flag for dbAppend (), InvalidBuffer and control of transactions. 
   
* SQL_PUTVALUE () / SQL_GETVALUE () works with Buffer now. 
* SQL_GOCOLD () implementation 
* New function to build a SQL command (INSERT / UPDATE): SQL_WRITERECORD () 
   
* Support for LOGICAL / DATE fields in CREATE () / REPLACE 
   
    Comments on SQL_RECCOUNT (): 
    To compute the correct value of SQL_RECCOUNT () I suggest using the function 
    MAX () and not the value of COUNT () since we have 3 records with values 
    different: 
   
    Ex: 
        SQL_RECNO FIRST LAST AGE 
        ************************************************** ***********************
           1 HARBOUR PROJECT 9 
           2 XHARBOUR PROJECT 5 
           3 DBase VULCAN 28 
           4 CLIPPER SUMMER 23 
        ************************************************** ***********************
        Reccount: 4 
   
    After GOTO 3 / DELETE / PACK: 

        SQL_RECNO FIRST LAST AGE 
        ************************************************** ***********************
           1 HARBOUR PROJECT 9 
           2 XHARBOUR PROJECT 5 
           4 CLIPPER SUMMER 23 
        ************************************************** ***********************
        Reccount: 3 
       
If we try to GOTO 3 the result is EOF ()... but i preferred not to amend this code.

[From portuguese brazilian:]
Olá Antonio!

Estive dedicando algum tempo ao SQLWin e fiz algumas alterações que gostaria de lhe apresentar:

Code: Select all

*  Notei que é necessário atribuir alguns valores padrões para os itens de aWAData[] para evitar erros com valores NIL como no caso de um APPEND BLANK ser chamado ANTES de um RecCount(). Eu ajustei isto.
   
*  Criado algumas constantes para controlar os possíveis drivers SQL em uso.
   
*  GetFieldNames()/GetFieldEmptyValues() agora recebe um parâmetro adicional para poder detectar o tipo de driver em uso e formatar o retorno corretamente. 
   
*  Nova função SQLGetFullTableName() que retorna o nome da tabela com o seu SCHEMA dentro do banco de dados. 

*  Criada a função SQLAdjustFn() que formata o nome do arquivo passado como argumento para um nome válido dentro do banco de dados. Ideal para ser usado em CREATE, USE, COPY, etc..
    
*  GoBottom implementation
*  Transaction counter
   
*  Introduzido um flag para dbAppend(), InvalidBuffer & controle de transações.
   
*  SQL_PUTVALUE() / SQL_GETVALUE() works with Buffer now.
*  SQL_GOCOLD() implementation
*  New function to build a SQL command (INSERT/UPDATE): SQL_WRITERECORD()
   
*  Support for LOGICAL/DATE fields in CREATE() / REPLACE
   
   Comentários sobre SQL_RECCOUNT():
   Para computar o valor correto de SQL_RECCOUNT() eu sugeriria utilizar a função 
   MAX() e não o valor de COUNT() visto que podemos ter 3 registros com valores 
   diferentes:
   
   Ex: 
       SQL_RECNO     FIRST                LAST                 AGE
       *************************************************************************
          1          HARBOUR              PROJECT              9
          2          XHARBOUR             PROJECT              5
          3          DBase                VULCAN               28                            
          4          CLIPPER              SUMMER               23
       *************************************************************************
       Reccount: 4          
   
   After GOTO 3 / DELETE / PACK :   

       SQL_RECNO     FIRST                LAST                 AGE
       *************************************************************************
          1          HARBOUR              PROJECT              9
          2          XHARBOUR             PROJECT              5
          4          CLIPPER              SUMMER               23
       *************************************************************************
       Reccount: 3
       
   Se tentarmos um GOTO 3 pela lógica anterior resultaria em um EOF(), mas eu 
   preferi não alterar o código da função.

Download here: http://www.kssoftware.com.br/SQLWIN.ZIP

Aguardo comentários sobre as alterações propostas e espero contribuir de algum modo!

Post by **Antonio Linares** » Tue Sep 16, 2008 4:27 pm

Vailton,

Many thanks for your contributions to SQLWIN

In order to keep track of changes until we reach a workable version (to be uploaded to the harbour project SVN), we have arranged a page on our wiki, so we can visually find the differences from one version to the next one.

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

I send you an email with your login and password to the wiki so you can update the wiki, and we can easily track the changes into its source code

p.s. Much nicer Avatar, thanks

(though your personal photo would be much more appreciated by all of us)

Post by **Antonio Linares** » Tue Sep 16, 2008 4:37 pm

Vailton,

Please upload your changes (the entire sqlwin.prg) to the wiki:

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

so we can see your modifications in the source code. Thanks

You should have received an email with your login and password for the wiki.

vailtom · Post by **vailtom** » Tue Sep 16, 2008 5:24 pm

Ok I am waiting for the mail until it reached nothing.

Post by **Antonio Linares** » Tue Sep 16, 2008 5:32 pm

Vailton,

It has been sent to renato@sqllib.com.br

Should we use a different one ? thanks,

vailtom · Post by **vailtom** » Tue Sep 16, 2008 5:42 pm

Antonio, please send to vailtom@gmail.com!

Gracias.

Post by **Antonio Linares** » Tue Sep 16, 2008 5:56 pm

Vailton,

Already sent

vailtom · Post by **vailtom** » Tue Sep 16, 2008 6:19 pm

Antonio,

I can simply paste the entire source code that changed on this Wiki page?

Sorry many questions, is that never before used a Wiki.

Post by **Antonio Linares** » Tue Sep 16, 2008 6:32 pm

Vailton,

Yes. Paste it in between:

...
<code clipper>
...all sqlwin.prg code
</code>

vailtom · Post by **vailtom** » Tue Sep 16, 2008 6:56 pm

I have updated the code on page Antonio. As in my tests I split the main routines and routines to test the RDD in separate files, I took the liberty of creating another section in the Wiki for these routines.

I await comments,

PS: Excuse me for my bad English. I have done much use of Google Translate by these days.

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

Vailton,

Ok, very good

Now we can easily see the new changes:

http://wiki.fivetechsoft.com/doku.php?i ... nt&do=diff

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

vailtom · Post by **vailtom** » Tue Sep 16, 2008 7:38 pm

Very interesting this ... Were you able to test changes? What think?