Page 1 of 2

HMGSCRIPT 0.37

Posted: Sat Aug 04, 2012 12:47 pm
by Roberto Lopez
Hi All,

I've completed the new dbf files support.

As I've already pointed, since the dbf files support was dropped from PHP standard distributions, I've decided to code from the scartch a new class to do that.

Please, use carefully (specially to write operations) since the code is fully new and must be considered ALPHA.

Operations that set or get the field content handles all data types (original character, numeric, logical and date) as strings.

There is no memo support.

See the sample code for more info.

If you are wondering why is the reason to do this, it is simple: Imagine that you have a Harbour based app running in a LAN and shared by various users, and you want to access the same files with a web client. The only thing that you need is to install an AMP server in the machine where the files are located and make the machine available via Internet, then HMGSCRIPT apps and LAN apps could share the same data.

IMPORTANT: I'VE NOT TESTED THE CLASS IN SUCH ENVIRONMENT YET, PLEASE CONSIDER THAT SOME ADJUSTMENTS COULD BE REQUIRED (SPECIALLY REGARDING SHARING AND LOCKING). THERE IS NO SECURITY IMPLEMENTED (YOU MUST DO IT FOR ANY REAL WORLD USE). USE FOR TEST ONLY AND REPORT ANY PROBLEM FOUND ON THIS THREAD. IDEAS AND CODE TO ENHANCE THE CLASS ARE WELCOME.
NEW ON RELEASE 0.37

- new: getRecno( nRow ) Browse method.

- new: FieldPut ( cFile , nRecno , nField , cValue ) function. Changes a record in a dbf file.

- new: Delete ( cFile , nRecno ) function. Mark a record as deleted in a dbf file.

- new: Recall ( cFile , nRecno ) function. Removes a delete mark from a record of a dbf file.

- new: FieldGet ( cFile , nRecno , nField ) function. Gets a field from a record of a dbf file.

- new: Append ( cFile ) function. Appends an empty record to a dbf file and returns its recno.

Roberto Lopez (http://www.hmgforum.com)
http://sourceforge.net/projects/hmgscript/

Enjoy!

Re: HMGSCRIPT 0.37

Posted: Sat Aug 04, 2012 12:54 pm
by esgici
GREAT :!:

Thanks Roberto :D

Best regards

Re: HMGSCRIPT 0.37

Posted: Sat Aug 04, 2012 2:11 pm
by bpd2000
Excellant Roberto Lopez

Re: HMGSCRIPT 0.37

Posted: Sun Aug 05, 2012 3:03 am
by Rathinagiri
Fantastic work Roberto.

Re: HMGSCRIPT 0.37

Posted: Mon Aug 06, 2012 1:07 pm
by claudiotedesco
Hola Roberto

Este fin de semana estuve probando el HMGSCRIPT y te felicito
El unico inconveniente que tengo es que me da error cuando quiero usar la BASE

xBase Browse Test (Click Headers To Sort)
Not Found

The requested URL /php/browse.php was not found on this server.


Yo instale VERTRIGOSERV correctamente pero no se si la carpeta hay que descomprimirla en el directorio WWW u otro lugar
Gracias por la ayuda
Saludos
Claudio

Re: HMGSCRIPT 0.37

Posted: Mon Aug 06, 2012 1:16 pm
by Roberto Lopez
claudiotedesco wrote:
Yo instale VERTRIGOSERV correctamente pero no se si la carpeta hay que descomprimirla en el directorio WWW u otro lugar
Gracias por la ayuda
Saludos
Claudio
Debes copiar la carpeta www de HMGSCRIPT a la carpeta www de vertrigo. Debería funcionar sin problemas.

Re: HMGSCRIPT 0.37

Posted: Mon Aug 06, 2012 1:31 pm
by claudiotedesco
Funciono correctamente
Gracias

Claudio

Re: HMGSCRIPT 0.37

Posted: Thu Sep 06, 2012 11:20 pm
by RIT
That most interesting project, Congratulations and thanks.

Grettings,
RIT.

Re: HMGSCRIPT 0.37

Posted: Tue Sep 18, 2012 1:56 pm
by nelstu
He estado trajando un poco con hmgscript y funciona perfecto!!!!!!!!

Base de datos mysql

Tengo un par de dudas

1.- como puedo agregar datos de una tabla a un combobox


2.-es posible controlar el largo del textbox

slds y gracias

Nelson Stuardo

Re: HMGSCRIPT 0.37

Posted: Wed Sep 19, 2012 7:50 pm
by nelstu
el largo del textbox ya lo solucione, necesito ver como cargar el combobox

slds

NS