Search found 1585 matches

by serge_girard
Fri Aug 18, 2017 5:00 pm
Forum: Self Introduction
Topic: The last novice
Replies: 56
Views: 1357

Re: The last novice

Eduardo, 'Many small bussines and profesionals needs solid desktop app, and there is were we must focuse.' This is very true. I don't see any of my programs (apps...) running on a cellphone. The screen and buttons are too small etc. A desktop is better for large amounts of data. Nowadays thieves wil...
by serge_girard
Fri Aug 18, 2017 6:09 am
Forum: General Discussions
Topic: Happy Birthday Rathinagiri!
Replies: 16
Views: 115

Re: Happy Birthday Rathinagiri!

Rathi, a very happy birthday to you ! And, of course, many returns!

Serge
by serge_girard
Wed Aug 16, 2017 6:05 am
Forum: HMG General Help
Topic: Hi, how do I execute the loop by step with a one-button condition using for / next or while
Replies: 7
Views: 213

Re: Hi, how do I execute the loop by step with a one-button condition using for / next or while

Jair, In the main: lSTOP := .f. + @ 600,10 BUTTON Start_STOP ; CAPTION 'Cancel' ; WIDTH 80 ; HEIGHT 30 ; ACTION {lSTOP := .T. } ; FONT "Arial" SIZE 09 ; TOOLTIP "Stop searching " ; FLAT Before the loop: lSTOP := .F. In the loop: WHILE .. DO EVENTS IF lSTOP EXIT ENDIF ENDDO This I use to stop loops! ...
by serge_girard
Tue Aug 15, 2017 11:47 am
Forum: HMG General Help
Topic: MySql revisited
Replies: 43
Views: 2105

Re: MySql revisited

Great Job Dragan ! Thanks, Serge
by serge_girard
Sun Aug 13, 2017 8:04 am
Forum: General Discussions
Topic: Happy birthday Marek
Replies: 23
Views: 261

Re: Happy birthday Marek

Marek, many happy birthdays !!!

Serge
by serge_girard
Thu Aug 10, 2017 12:12 pm
Forum: HMG General Help
Topic: MySql revisited
Replies: 43
Views: 2105

Re: MySql revisited

And PERSONEL.SQL attached!
by serge_girard
Thu Aug 10, 2017 11:13 am
Forum: HMG General Help
Topic: MySql revisited
Replies: 43
Views: 2105

Re: MySql revisited

Hello Dragan, I know it is for beginners but beginners are always eager to see some fast results... This one can use for inserting mass (a bit slow beacuse of the possibilties of duplicate keys: USE F0001 INDEX ON STR(SHOP_ID,2,0) + SUBSTR(DTOC(REC_DATE),7,4) + SUBSTR(DTOC(REC_DATE),4,2) + SUBSTR(DT...
by serge_girard
Thu Aug 10, 2017 11:06 am
Forum: PDF Generation
Topic: HPDF SET PAGENUMBERING
Replies: 4
Views: 180

Re: HPDF SET PAGENUMBERING

Hello ljubacirovic,

Please take a look at the demo I send in this topic:

viewtopic.php?f=5&t=5107

Serge
by serge_girard
Wed Aug 09, 2017 5:43 pm
Forum: HMG General Help
Topic: MySql revisited
Replies: 43
Views: 2105

Re: MySql revisited

Here is another one (with PDF printing): #include "hmg.ch" FUNCTION MAIN() /***************/ PUBLIC dbo PUBLIC pHOST := 'hostname' PUBLIC pDBUSER := 'user' PUBLIC pDBPW := 'pasword' PUBLIC pDBNAME := 'dbname' SET CENT ON SET DATE FRENCH If !IsWIndowActive (Form_1) DEFINE WINDOW Form_1 ; AT 0,0 ; WID...
by serge_girard
Wed Aug 09, 2017 5:22 pm
Forum: HMG General Help
Topic: MySql revisited
Replies: 43
Views: 2105

Re: MySql revisited

Hello, I made a little demo which shows the difference between working with DBF-files and MySQl. The meaning is to demonstrate how to calculate an total-amount by grouping on 2 fields. Structure: ------------ SHOP_ID Num 12 REC_DATE Date TOTAL Num 12.2 ... Both have the same structure and are the sa...