By geoken90 - Tue Jul 03, 2018 5:00 am
- Tue Jul 03, 2018 5:00 am
#815003
Hi everyone,
I have a stored procedure in mysql that returns lastnames based on a given parameter.
I am trying to call this procedure for a suggest control.
So, inside sql editor i have the following :
CALL fetch_lastnames_from_cost_centers(@@filter)
The suggest control seems to work but no results are returned.
I have also tried this :
SET @param = @@filter
CALL fetch_lastnames_from_cost_centers(@param)
But no results are returned either.
How can i call the mysql stored procedure inside sql editor ??
I have a stored procedure in mysql that returns lastnames based on a given parameter.
I am trying to call this procedure for a suggest control.
So, inside sql editor i have the following :
CALL fetch_lastnames_from_cost_centers(@@filter)
The suggest control seems to work but no results are returned.
I have also tried this :
SET @param = @@filter
CALL fetch_lastnames_from_cost_centers(@param)
But no results are returned either.
How can i call the mysql stored procedure inside sql editor ??