I have a stored procedure I would like to call to populate a work table as a preprocessor to an SQL client requester. Syntax would be helpful. Thanks
SQL stored procedure call from X3
I have a stored procedure I would like to call to populate a work table as a preprocessor to an SQL client requester. Syntax would be helpful. Thanks
SQL stored procedure call from X3
Thanks been looking for this code
Hi.
Is there a way to get returned values?
Try sql instead of execsql
For (Char ITMREF,Char ITMDSC,Char ITMDSC2) From "5" Sql REQUEST(0..1) As [YITMS]
Infbox num$([YSITES]ITMREF)
Break
Next
It works with regular sql query store procedure. I haven't made it work with dynamic sql.
Thank you Sheila.
*Community Hub is the new name for Sage City