Page 1 of 5

HMGSCRIPT R42

Posted: Sun Dec 28, 2014 1:28 pm
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!

Re: HMGSCRIPT R42

Posted: Sun Dec 28, 2014 4:03 pm
by Rathinagiri
Wonderful Roberto.

Re: HMGSCRIPT R42

Posted: Sun Dec 28, 2014 5:09 pm
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.)

Re: HMGSCRIPT R42

Posted: Sun Dec 28, 2014 5:34 pm
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 :)

Re: HMGSCRIPT R42

Posted: Tue Jul 21, 2015 8:07 pm
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

Re: HMGSCRIPT R42

Posted: Tue Jul 21, 2015 9:36 pm
by EduardoLuis
Hi Roberto:

Thanks for sharing your knowledge with us.- As you allways did: A GREAT JOB.-
With regards. Eduardo

Re: HMGSCRIPT R42

Posted: Tue Mar 01, 2016 12:00 pm
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

Re: HMGSCRIPT R42

Posted: Tue Mar 01, 2016 2:43 pm
by bpd2000
Wonderful Roberto Lopez

Re: HMGSCRIPT R42

Posted: Tue Mar 01, 2016 9:29 pm
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.

Re: HMGSCRIPT R42

Posted: Wed Mar 02, 2016 9:57 am
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.