slynch401k
Posts: 15
|
| Posted: 11/25/2006, 10:21 AM |
|
I'm a little stuck. I want to run a stored Procedure after I hit the submit button on an editable grid.
I know that I can run a stored procedure via a custom insert but thats not want I need as I need to post the changed records first.
What would be really nice would be the ability to "add action" to the Submit button called "Run SP", then you just name the stored procedure.
Does anyone have any code or can lead me down the right path. I was also thinking of adding an insert button to run the SP, and then trying to call it after I clicked the Submit button but I do not know how to do this either.
Thanks, this is a good product with the potential to be great.
|
 |
 |
Edd
Posts: 547
|
| Posted: 11/25/2006, 2:32 PM |
|
A trigger wouldn't surfice? Or are you trying to make it difficult for yourself and do it after the entire screen is posted?
Edd
_________________
Accepting and instigating change are life's challenges.
http://www.syntech.com.au |
|
|
|
slynch401k
Posts: 15
|
| Posted: 11/25/2006, 4:00 PM |
|
Ed:
Thanks I will look into it. The stored procedure is updating another table that I was using the UserID as the parameter which is the same as the companyID.
So I quess I could tell the trigger to look at the field just updated, grab the CompanyID and run the query using that as the parameter. If I am way off base let me know so I won't spend a few hours researching.
Right now I set up another page that it goes to with a submit button that runs the SP. An extra page but it requires no programming.
Thanks for the reply.
|
|
|
|
peterr
Posts: 5971
|
| Posted: 11/25/2006, 7:12 PM |
|
The events are available for this. For example you can try the "After Insert" event with this code: http://forums.codecharge.com/posts.php?post_id=82636
_________________
Peter R.
YesSoftware Forums Moderator
For product support please visit http://support.yessoftware.com |
|
|
|
