Search found 1583 matches

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: 182

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: 2078

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: 20
Views: 205

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: 2078

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: 2078

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: 171

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: 2078

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: 2078

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...
by serge_girard
Wed Aug 09, 2017 11:43 am
Forum: HMG Tutorials and Tips
Topic: How do i call a procedure
Replies: 28
Views: 752

Re: How do i call a procedure

Granddaddys all together!

Serge
by serge_girard
Wed Aug 09, 2017 11:33 am
Forum: HMG Tutorials and Tips
Topic: How do i call a procedure
Replies: 28
Views: 752

Re: How do i call a procedure

Hi Esgici !

I have 4 children and 2 grandchildren. Ages 15 and 18 months, so both very little. I adore both and indeed one of most happiness of the world .
I actually have them each wednesday (now sleeping, so a minute free time!)

Serge