Call custom stored procedure

This public forum is for user-to-user discussions of ASP.NET Maker. Note that this is not support forum.

Call custom stored procedure

Postby dire » Wed Oct 18, 2017 4:15 pm

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?
dire
 
Posts: 34
Joined: Mon Sep 26, 2016 7:53 pm

Re: Call custom stored procedure

Postby Webmaster » Thu Oct 19, 2017 9:27 am

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:
viewtopic.php?f=7&t=40119
Webmaster
 
Posts: 10733
Joined: Fri Aug 06, 2004 5:59 pm


Return to General Discussion (ASP.NET Maker)