Search found 1674 matches

by serge_girard
Mon Nov 20, 2017 4:58 pm
Forum: HMG General Help
Topic: MySQL question
Replies: 6
Views: 197

Re: MySQL question

Thanks Marek, Maybe it is. I will try to find out!

Serge
by serge_girard
Mon Nov 20, 2017 9:57 am
Forum: HMG General Help
Topic: MySQL question
Replies: 6
Views: 197

Re: MySQL question

Rathi, It works fine in PHP: $sql2 = "CALL GET_ALL_P0001() "; $res = $mysqli->query($sql2); while($row = $res->fetch_assoc()): $FIL_NR = $row["FIL_NR"] ; $PRES_NR = $row["PRES_NR"] ; $table .= '<tr><td>' . $FIL_NR . '</td><td>'. $PRES_NR . '</td></tr>' ; endwhile; Calling a UDF however works well: C...
by serge_girard
Mon Nov 20, 2017 8:34 am
Forum: General Discussions
Topic: Happy Birthday to Amarante!
Replies: 8
Views: 87

Happy Birthday to Amarante!

Happy Birthday to Amarante!

Serge
by serge_girard
Mon Nov 20, 2017 8:22 am
Forum: HMG General Help
Topic: MySQL question
Replies: 6
Views: 197

Re: MySQL question

Hi Rathi,

Thanks for the tip. Regretfully this doesn't work either: message FUNCTION .. doesn't exist.

I tried also: cQuery2 := 'GET_ALL_P0001()'

I thought it would be about the same as in PHP: http://php.net/manual/en/mysqli.quicks ... dures.php

Serge
by serge_girard
Sun Nov 19, 2017 4:53 pm
Forum: HMG General Help
Topic: MySQL question
Replies: 6
Views: 197

MySQL question

Hello, Does anybody know how to call a stored-procedure from within HMG? I now have a procedure: CREATE PROCEDURE GET_ALL_P0001() BEGIN SELECT * FROM P0001; END Allready stored in MySQL and then I try to call it: IF SQL_Connect(qHST,qUSR,qPAW,qDBN) == Nil MSGINFO('SQL_CONNECT_ERROR' ,'NOK' ) RETURN ...
by serge_girard
Mon Nov 13, 2017 7:47 am
Forum: General Discussions
Topic: Welcome to our 700th member!
Replies: 9
Views: 269

Welcome to our 700th member!

Apparantly we got our 700th member!

Eric.Developer is the lucky one, so give him a nice welcome!

Serge
by serge_girard
Sun Nov 12, 2017 9:22 am
Forum: General Discussions
Topic: Happy Birthday to Danny !!
Replies: 8
Views: 165

Happy Birthday to Danny !!

Happy Birthday to Danny !!

Serge
by serge_girard
Fri Nov 10, 2017 3:47 pm
Forum: General Discussions
Topic: Happy Birthday to Andrés andyglez!!
Replies: 10
Views: 173

Happy Birthday to Andrés andyglez!!

Happy Birthday to Andrés !!

Serge
by serge_girard
Fri Nov 10, 2017 11:16 am
Forum: General Discussions
Topic: Happy Birthday to Serge!!!
Replies: 26
Views: 389

Re: Happy Birthday to Serge!!!

No need to be sorry (still celebrating!). Thanks all
Serge