HMGSCRIPT R42

Moderator: Rathinagiri

User avatar
Roberto Lopez
HMG Founder
Posts: 4004
Joined: Wed Jul 30, 2008 6:43 pm

HMGSCRIPT R42

Post by Roberto Lopez »

New in R42

- new: jspdf library included by default, allowing the creation client-side pdf docs.

- new: jspdf samples integrated in desktop demo.

- modified: data demo. It allows now the creation of a client-side pdf report from a query
done via httpRequest function.
After thinking a lot about this and re-testing JavaScript client-side PDF libraries, I've decided that the best way to go, is to generate PDFs in client-side.

So, I've integrated jspdf library to HMGSCRIPT.

This decision is consistent with general HMGSCRIPT philosophy (ask server for database operations only).

The data demo, has now a new feature ('PDF Report'). It queries remote database via httpRequest function, get a recordset array with the result as response and locally generates the PDF report.

All demos included (doing nearly everything you could need) works perfectly on Chrome, Firefox and Safari.

Since Sourceforge is experiencing problems (I'm unable to upload files) I'm attaching to this message a source-only version of R42. To make it work, you simply must to merge it, with an existing R41.

Download: https://sourceforge.net/projects/hmgscript

Enjoy!
Regards/Saludos,

Roberto


(Veritas Filia Temporis)
User avatar
Rathinagiri
Posts: 5471
Joined: Tue Jul 29, 2008 6:30 pm
DBs Used: MariaDB, SQLite, SQLCipher and MySQL
Location: Sivakasi, India
Contact:

Re: HMGSCRIPT R42

Post by Rathinagiri »

Wonderful Roberto.
East or West HMG is the Best.
South or North HMG is worth.
...the possibilities are endless.
User avatar
Czarny_Pijar
Posts: 172
Joined: Thu Mar 18, 2010 11:31 pm
Location: 19.2341 E 50.2267 N

Re: HMGSCRIPT R42

Post by Czarny_Pijar »

I knew about it! Shooting new versions so often, HMG also stands for Heavy Machine Gun.
(Please do not get angry, it's just an innocent joke.)
User avatar
Roberto Lopez
HMG Founder
Posts: 4004
Joined: Wed Jul 30, 2008 6:43 pm

Re: HMGSCRIPT R42

Post by Roberto Lopez »

Czarny_Pijar wrote:I knew about it! Shooting new versions so often, HMG also stands for Heavy Machine Gun.
(Please do not get angry, it's just an innocent joke.)
Well... what can I say...

When an idea comes to my head, I don't find peace until I code it... then I want to share the code :)
Regards/Saludos,

Roberto


(Veritas Filia Temporis)
User avatar
rizaflevi
Posts: 16
Joined: Sun Sep 01, 2013 3:53 am
Location: Indonesia
Contact:

Re: HMGSCRIPT R42

Post by rizaflevi »

Hi Roberto,

I really appreciate about your HmgScript project. Thanks a lot for this.

Is there any sample for access MySql database to a grid ?
Thanks again.

Rgds,
Riza
EduardoLuis
Posts: 682
Joined: Tue Jun 04, 2013 6:33 pm
Location: Argentina

Re: HMGSCRIPT R42

Post by EduardoLuis »

Hi Roberto:

Thanks for sharing your knowledge with us.- As you allways did: A GREAT JOB.-
With regards. Eduardo
User avatar
mol
Posts: 3718
Joined: Thu Sep 11, 2008 5:31 am
Location: Myszków, Poland
Contact:

Re: HMGSCRIPT R42

Post by mol »

Hi!
I have a little time to look at hmgscript (I need to create a little web app).
Where can I find few samples? How to manipulate mysql database?

Best regards, Marek
User avatar
bpd2000
Posts: 1207
Joined: Sat Sep 10, 2011 4:07 am
Location: India

Re: HMGSCRIPT R42

Post by bpd2000 »

Wonderful Roberto Lopez
BPD
Convert Dream into Reality through HMG
User avatar
Roberto Lopez
HMG Founder
Posts: 4004
Joined: Wed Jul 30, 2008 6:43 pm

Re: HMGSCRIPT R42

Post by Roberto Lopez »

mol wrote:Hi!
I have a little time to look at hmgscript (I need to create a little web app).
Where can I find few samples? How to manipulate mysql database?

Best regards, Marek
Even R42 includes Harbour CGI server examples only, it is 'back-end agnostic'. Meaning that you could use a php back-end, using the same HMGSCRIPT client samples (in fact, my most recent HMGSCRIPT development uses PHP/MySql back-end). For Windows desktop counterpart of the app, I use SQLMIX RDD (I'm leaving Harbour CGI approach).

So, with this HMGSCRIPT code:

Code: Select all

	response = httpRequest ( 'test.php' ); 
You are calling test.php server procedure and the value returned by this php procedure are stored on 'response' variable. So any php-MySql example will work.

Moreover, from some time ago, I'm working in various modifications towards a new release fully oriented to php-MySql. I hope to release it in the next months.

My recomendation for testing is Uniform WAMP server: http://www.uniformserver.com/ It is lightweight, fast and simple.
Regards/Saludos,

Roberto


(Veritas Filia Temporis)
User avatar
mol
Posts: 3718
Joined: Thu Sep 11, 2008 5:31 am
Location: Myszków, Poland
Contact:

Re: HMGSCRIPT R42

Post by mol »

Thanks for info, Roberto!
I caught ideology of hmgscript, I think.
I'm trying now to create forms. Later, I'll try to add some php code to retrieve data from mysql database. I can't use cgi scripts because of server limitations.
Post Reply