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

Moderator: Rathinagiri

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

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

Post by Rathinagiri »

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 428 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: 3991
Joined: Wed Jul 30, 2008 6:43 pm
Has thanked: 85 times
Been thanked: 184 times

Post by Roberto Lopez »

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

Roberto


(Veritas Filia Temporis)

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

Post by Rathinagiri »

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: 3991
Joined: Wed Jul 30, 2008 6:43 pm
Has thanked: 85 times
Been thanked: 184 times

Post by Roberto Lopez »

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: 3991
Joined: Wed Jul 30, 2008 6:43 pm
Has thanked: 85 times
Been thanked: 184 times

Post by Roberto Lopez »

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: 245
Joined: Sat Aug 02, 2008 5:03 pm
Has thanked: 7 times
Been thanked: 15 times

Post by Carlos Britos »

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: 3991
Joined: Wed Jul 30, 2008 6:43 pm
Has thanked: 85 times
Been thanked: 184 times

Post by Roberto Lopez »

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: 4543
Joined: Wed Jul 30, 2008 9:17 pm
DBs Used: DBF
Location: iskenderun / Turkiye
Has thanked: 411 times
Been thanked: 120 times
Contact:

Post by esgici »

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

Regards

--

Esgici
Viva INTERNATIONAL HMG :D

User avatar
IMATECH
Posts: 179
Joined: Sun May 27, 2012 9:33 pm
Location: Brazil: Goiânia-GO.
Has thanked: 9 times
Been thanked: 3 times

Post by IMATECH »

Hi Carlos Britos !

Please: clear browser cache and temp files...

Then try again...



Regards
M., Ronaldo

By: IMATECH

Imation Tecnologia

Carlos Britos
Posts: 245
Joined: Sat Aug 02, 2008 5:03 pm
Has thanked: 7 times
Been thanked: 15 times

Post by Carlos Britos »

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