HMGSCRIPT 0.37

HMG announcements; Latest HMG-related news, releases, fixes and updates.

Moderator: Rathinagiri

User avatar
Roberto Lopez
HMG Founder
Posts: 3902
Joined: Wed Jul 30, 2008 6:43 pm
Has thanked: 13 times
Been thanked: 137 times

HMGSCRIPT 0.37

Post by Roberto Lopez » Sat Aug 04, 2012 12:47 pm

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!
Regards/Saludos,

Roberto


(Veritas Filia Temporis)

User avatar
esgici
Posts: 4363
Joined: Wed Jul 30, 2008 9:17 pm
DBs Used: DBF
Location: iskenderun / Turkiye
Has thanked: 247 times
Been thanked: 91 times
Contact:

Post by esgici » Sat Aug 04, 2012 12:54 pm

GREAT :!:

Thanks Roberto :D

Best regards
Viva INTERNATIONAL HMG :D

User avatar
bpd2000
Posts: 963
Joined: Sat Sep 10, 2011 4:07 am
Location: India
Has thanked: 136 times
Been thanked: 43 times

Post by bpd2000 » Sat Aug 04, 2012 2:11 pm

Excellant Roberto Lopez
BPD
Convert Dream into Reality through HMG

User avatar
Rathinagiri
Posts: 5181
Joined: Tue Jul 29, 2008 6:30 pm
DBs Used: MariaDB, SQLite, SQLCipher and MySQL
Location: Sivakasi, India
Has thanked: 142 times
Been thanked: 131 times
Contact:

Post by Rathinagiri » Sun Aug 05, 2012 3:03 am

Fantastic work Roberto.
East or West HMG is the Best.
South or North HMG is worth.
...the possibilities are endless.

claudiotedesco
Posts: 132
Joined: Thu Jul 31, 2008 12:05 pm

Post by claudiotedesco » Mon Aug 06, 2012 1:07 pm

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
Attachments
error.jpg
error.jpg (58.82 KiB) Viewed 19300 times

User avatar
Roberto Lopez
HMG Founder
Posts: 3902
Joined: Wed Jul 30, 2008 6:43 pm
Has thanked: 13 times
Been thanked: 137 times

Post by Roberto Lopez » Mon Aug 06, 2012 1:16 pm

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.
Regards/Saludos,

Roberto


(Veritas Filia Temporis)

claudiotedesco
Posts: 132
Joined: Thu Jul 31, 2008 12:05 pm

Post by claudiotedesco » Mon Aug 06, 2012 1:31 pm

Funciono correctamente
Gracias

Claudio

User avatar
RIT
Posts: 13
Joined: Mon Oct 04, 2010 1:32 am
Location: Osorno, Chile
Contact:

Post by RIT » Thu Sep 06, 2012 11:20 pm

That most interesting project, Congratulations and thanks.

Grettings,
RIT.

nelstu
Posts: 58
Joined: Mon Jul 30, 2012 10:41 pm

Post by nelstu » Tue Sep 18, 2012 1:56 pm

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

nelstu
Posts: 58
Joined: Mon Jul 30, 2012 10:41 pm

Post by nelstu » Wed Sep 19, 2012 7:50 pm

el largo del textbox ya lo solucione, necesito ver como cargar el combobox

slds

NS

Post Reply