Search found 1676 matches

by serge_girard
Thu Nov 23, 2017 9:30 am
Forum: HMG General Help
Topic: MySQL question
Replies: 10
Views: 279

Re: MySQL question

Thanks Koke and Dragan, The function I made is working well and is no problem, as I wrote before. The problem is the stored procedure. The procedure itself is well defined etc. and working in PHP but not in HMG. I call the procedure as following: cQuery2 := 'CALL GET_fil_P0001(11, @npres_nr);' cQuer...
by serge_girard
Wed Nov 22, 2017 4:46 pm
Forum: HMG General Help
Topic: MySQL question
Replies: 10
Views: 279

Re: MySQL question

Koke,

I'm afraid I don't understand what you mean!
Can you explain?
The calling PROC is always a string-array.

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

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: 10
Views: 279

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

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: 10
Views: 279

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: 10
Views: 279

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

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

Happy Birthday to Danny !!

Happy Birthday to Danny !!

Serge