MySQL question

General Help regarding HMG, Compilation, Linking, Samples

Moderator: Rathinagiri

User avatar
serge_girard
Posts: 3161
Joined: Sun Nov 25, 2012 2:44 pm
DBs Used: 1 MySQL - MariaDB
2 DBF
Location: Belgium
Contact:

Re: MySQL question

Post by serge_girard »

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:

Code: Select all

cQuery2 := 'CALL GET_fil_P0001(11, @npres_nr);'
cQuery2 += 'SELECT @npres_nr;'
This gives: can't return a result set in the given context.

Serge
There's nothing you can do that can't be done...
Post Reply