Can I Call a stored Procedure from a GRIDs Field Lookup?
example:
CALL respercontacts(@[v_rid])
The above seems compiles ok but I don’t get any response - any help appreciated.
Hi,
I doubt that it will run in a grid. You will most likely get the ‘#2014… out of sync…’ error.
Mysql reference says:
“This can happen, for example, if you are using mysql_use_result() and try to execute a new query before you have called mysql_free_result(). It can also happen if you try to execute two queries that return data without calling mysql_use_result() or mysql_store_result() in between.”
Mysql_use_result() is a C function in the mysql library, and is used internally in PHP.
SC is still using the standard mysql driver and you need the mysqli driver for this feature (call a stored procedure multiple times without clearing the cursor).
jsb