Page 1 of 1

Call custom stored procedure

Posted: Wed Oct 18, 2017 4:15 pm
by dire

Hi,

I need an advice on how to call custom stored procedure on MSSQL.

On table Offer is field with offer number (1000)
custom filed "count" on table Offer with specific number (100)

I want to call stored procedure on MSSQL, which will generate 100 offers starting from 1000.

So I need custom button to call store procedure with these two parameters.

I think in server Events->Table-Specific custom function with ew_Execute?


Re: Call custom stored procedure

Posted: Thu Oct 19, 2017 9:27 am
by Webmaster
  1. To add a custom action button, read help file topic: Server Events and Client Scripts -> Table-Specific -> List Page -> Page_Load / Row_CustomAction
  2. To execute a stored procedure, read help file topic: Server Events and Client Scripts -> Some Global Objects and Methods -> ew_Execute. Also read:
    http://www.hkvforums.com/viewtopic.php?f=7&t=40119