FiveTech Software tech support forums

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

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

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

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

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

Vailton,

Yes, mostly.

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

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 Expand view: * 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 Expand view: * 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!

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)

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.

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

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

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,

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

Antonio, please send to vailtom@gmail.com!

Gracias.

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

Vailton,

Already sent :-)

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.
:oops:

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

Vailton,

Yes. Paste it in between:

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

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.
:wink:

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

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

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

FiveTech Software tech support forums

SQLWIN - a free RDD for SQL

Who is online