HMGSCRIPT R42

Moderator: Rathinagiri

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

HMGSCRIPT R42

Post by Roberto Lopez » Sun Dec 28, 2014 1:28 pm

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: 5163
Joined: Tue Jul 29, 2008 6:30 pm
DBs Used: MariaDB, SQLite, SQLCipher and MySQL
Location: Sivakasi, India
Has thanked: 129 times
Been thanked: 130 times
Contact:

Post by Rathinagiri » Sun Dec 28, 2014 4:03 pm

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

Post by Czarny_Pijar » Sun Dec 28, 2014 5:09 pm

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: 3899
Joined: Wed Jul 30, 2008 6:43 pm
Has thanked: 13 times
Been thanked: 135 times

Post by Roberto Lopez » Sun Dec 28, 2014 5:34 pm

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: 13
Joined: Sun Sep 01, 2013 3:53 am
Location: Indonesia
Contact:

Post by rizaflevi » Tue Jul 21, 2015 8:07 pm

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: 517
Joined: Tue Jun 04, 2013 6:33 pm
Location: Argentina
Been thanked: 28 times

Post by EduardoLuis » Tue Jul 21, 2015 9:36 pm

Hi Roberto:

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

User avatar
mol
Posts: 2842
Joined: Thu Sep 11, 2008 5:31 am
Location: Myszków, Poland
Has thanked: 119 times
Been thanked: 64 times
Contact:

Post by mol » Tue Mar 01, 2016 12:00 pm

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: 948
Joined: Sat Sep 10, 2011 4:07 am
Location: India
Has thanked: 118 times
Been thanked: 42 times

Post by bpd2000 » Tue Mar 01, 2016 2:43 pm

Wonderful Roberto Lopez
BPD
Convert Dream into Reality through HMG

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

Post by Roberto Lopez » Tue Mar 01, 2016 9:29 pm

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: 2842
Joined: Thu Sep 11, 2008 5:31 am
Location: Myszków, Poland
Has thanked: 119 times
Been thanked: 64 times
Contact:

Post by mol » Wed Mar 02, 2016 9:57 am

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