Announcement

Collapse
No announcement yet.

Call a stored Procedure from a GRIDs Field Lookup

Collapse
X
  • Filter
  • Time
  • Show
Clear All
new posts

  • Call a stored Procedure from a GRIDs Field Lookup

    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.

  • #2
    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

    Comment

    Working...
    X