HMGSCRIPT 2012: Programming For The Web in The Right Way :)

Moderator: Rathinagiri

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

Re: HMGSCRIPT 2012: Programming For The Web in The Right Way

Post by Rathinagiri » Sat Jul 07, 2012 1:04 pm

Hi,

I have tried to connect MySQL database via a Harbour module but I couldn't.

I have included the module file, which is getting compiled successfully.
MySQL.zip
(30.18 KiB) Downloaded 134 times
First, I don't know where to place libmysql.dll (can we use a dll?!) and I don't know whether 'c' calls are allowed inside a module prg file via #pragma.

The error I have got is:

Error
Description: Unknown or unregistered symbol
Filename:
Operation: MYSQL_QUERY
OsCode: 0
GenCode: 1
SubCode: 6101
SubSystem: BASE
Args: NIL
ProcName: HANDLER_HRBSCRIPT
ProcLine: 2723
East or West HMG is the Best.
South or North HMG is worth.
...the possibilities are endless.

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

Post by Roberto Lopez » Sun Jul 08, 2012 3:35 am

HMGSCRIPT R30
- new: Browse 'nPageSize' optional parameter.

- new: Browse getPageSize() method().

- new: Browse loadPage( nPage ) method.

- new: Browse recordCount() method.

- new: Paged Browse demo.

- changed: TextBox setMask method renamed to setStringMask.

- changed: TextBox setCurrency method renamed to setNumericMask. Added new parameters.

setNumericMask ( nIintDigits , nDecimals , cDecimalSeparator ,
cGgroupSeparator , bAllowNegative, bLeftToRight,
cCurrencySymbol )

- new: TextBox setAsNumber(nValue) and getAsNumber() methods for numeric TextBox.
Enjoy!
Attachments
hmgscript.r30.zip
(1.62 MiB) Downloaded 213 times
Regards/Saludos,

Roberto


(Veritas Filia Temporis)

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

Post by Rathinagiri » Sun Jul 08, 2012 9:38 am

It looks very nice Roberto. Thanks.
East or West HMG is the Best.
South or North HMG is worth.
...the possibilities are endless.

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

Post by Roberto Lopez » Sun Jul 08, 2012 2:04 pm

rathinagiri wrote:It looks very nice Roberto. Thanks.
Well... since the basic needed things are in place, I'm working on tunning.

The paged Browse tabla has 10,000 records and the response is nearly instantaneous.

Despite my solution for big tables,, anyone can find his own, that fit better for his environment.

I've tested many different techniques, and the current appears to be the fastest one.
Regards/Saludos,

Roberto


(Veritas Filia Temporis)

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

Post by Roberto Lopez » Sun Jul 08, 2012 2:07 pm

rathinagiri wrote:Hi,

I have tried to connect MySQL database via a Harbour module but I couldn't.

I have included the module file, which is getting compiled successfully.
First, I don't know where to place libmysql.dll (can we use a dll?!) and I don't know whether 'c' calls are allowed inside a module prg file via #pragma.
I have no answers for this.

Perhaps, you shoul try to contact the authors, directly or via the Harbour forums:
* Harbour Project source code:
* uHTTPD (Micro HTTP server)
*
* Copyright 2009 Francesco Saverio Giudice <info / at / fsgiudice.com>
* Copyright 2008 Mindaugas Kavaliauskas (dbtopas at dbtopas.lt)
Regards/Saludos,

Roberto


(Veritas Filia Temporis)

Carlos Britos
Posts: 219
Joined: Sat Aug 02, 2008 5:03 pm
Has thanked: 6 times
Been thanked: 2 times

Post by Carlos Britos » Sun Jul 08, 2012 4:32 pm

Roberto Lopez wrote:HMGSCRIPT R30
Enjoy!
HI
I would like to test this, but I can´t download the file
I´ve tried with firefox 13, ie, opera, chrome
Only opera get a file ,but corrupted.
The strange thing, is I can get any file from the forum, only I can´t with hmgscripts R??.zip
Any idea how can I get it ?
thanks Carlos
Regards/Saludos, Carlos (bcd12a)

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

Post by Roberto Lopez » Sun Jul 08, 2012 4:47 pm

Carlos Britos wrote:
Roberto Lopez wrote:HMGSCRIPT R30
Enjoy!
HI
I would like to test this, but I can´t download the file
I´ve tried with firefox 13, ie, opera, chrome
Only opera get a file ,but corrupted.
The strange thing, is I can get any file from the forum, only I can´t with hmgscripts R??.zip
Any idea how can I get it ?
thanks Carlos
I've just downloaded it for test and all is working ok.
Regards/Saludos,

Roberto


(Veritas Filia Temporis)

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

Post by esgici » Sun Jul 08, 2012 5:01 pm

I've downloaded with Chrome and Firefox; no problem.

Regards

--

Esgici
Viva INTERNATIONAL HMG :D

User avatar
IMATECH
Posts: 167
Joined: Sun May 27, 2012 9:33 pm
Location: Brazil: Goiânia-GO.

Post by IMATECH » Sun Jul 08, 2012 5:10 pm

Hi Carlos Britos !

Please: clear browser cache and temp files...

Then try again...



Regards
M., Ronaldo

By: IMATECH

Imation Tecnologia

Carlos Britos
Posts: 219
Joined: Sat Aug 02, 2008 5:03 pm
Has thanked: 6 times
Been thanked: 2 times

Post by Carlos Britos » Sun Jul 08, 2012 7:04 pm

Chacal.GO wrote:Hi Carlos Britos !
Please: clear browser cache and temp files...
Then try again...
Regards
Hi
Ok, done but no luck :( , I will try it tomorow from another pc.
Regards/Saludos, Carlos (bcd12a)

Post Reply