Questions

Questions Filter:
All Unanswered Answered My Questions My Answers
Tag Filter:

Using a Stored Procedure in Custom Commands

Answer Accepted
I read in an earlier post that Kelly added the ability to use stored procedures in Custom Commands in v4.7. Did this get added and does it work? If it was added and working, I am having a problem getting it to work in my form., It could be a typo or syntax error on my part. I should note that I am using the FormX control in my Temmplate, so the {{PropertyName}} syntax is correct usage in the Param
customcommandsFormXstored procedure
0 votes
7 responses
1801 views
Steve Krantzman asked Dec 10, 2018 active Dec 20, 2018

ListBox pass parameter to form submit command as stored procedure

http://dnndev.com/fiddle/fid/737 All, I get an error however way I try and pass the listbox strings to the stored procedure. Can some one give the correct format to do this? -Error MESSAGE: Incorrect syntax near ')'.; ADDITIONAL INFO....List2:; List1:; FK_ID:5462; BYID:1; STACK TRACE: at KnowBetter.XModPro.FormFunctions.AddButtonClicked(XItem& xi) at KnowBetter.XModPro.XModPro.frmAddRecord_Add
databoundListBoxparameterstored procedure
0 votes
1 responses
2288 views
Paul.Buckley asked Dec 20, 2018 active Dec 20, 2018

Procedure or function expects parameter, which was not supplied.

Getting this error: "Procedure or function expects parameter '@disasterID', which was not supplied." See below for the fiddle of code, etc. Have profiler running which shows what XMP is sending to SQL; neither of these work and I get the same error. If I manually execute the stored procedure, enter the variables, everything works fine. Any ideas? http://dnndev.com/fiddle/fid/708
missingparameterstored procedure
0 votes
2 responses
4214 views
Jeff M. asked Jun 7, 2018 active Jun 13, 2018

Command button passing parameter to stored procedure

I've been banging my head against the wall trying to get this working. http://dnndev.com/fiddle/fid/687 I've got what I think is a straightforward command button template in one template, another template below that is supposed to receive the first templates commandbutton click and execute a stored procedure (listdatasource) using the passed parameter. I can run the second template independently w
commandbuttonparameterstored procedure
0 votes
1 responses
2198 views
Mark Guercio asked Jan 31, 2018 active Jan 31, 2018

On Submit

Is there any way I can..... Pressing the "add button" from a form, runs a stored procedure for inserting the record. If I "return an output" of the newly created ID from the stored procedure is there a way to use this variable in the redirect tag of the "add button" ??? Any thoughts or work arounds would be greatly appreciated. Thanks Mark
add formoutputredirectstored procedure
0 votes
1 responses
1932 views
Mark Trippier asked Dec 14, 2017 active Dec 14, 2017

Getting Good Answers

How do you get good answers to your questions?   Ask good questions. That means:

  1. Good Titles: Give your question a concise but informative title. Rather than "Email Forms", use "Sending multiple emails from forms".
  2. Do Your Research: Check out the XMod Pro help file, the XMod Pro Guide on this site, do a search in this Answers forum. Members are friendly and more than happy to help, but it's good etiquette to show you've done your homework.
  3. Is It Answerable? Your question should be practical and answerable. Provide clear and accurate details about your specific problem. Be sure to include all the pertinent information or links to images and examples. 
  4. Show Your Appreciation: If someone correctly answers your question, come back and ACCEPT the answer. That gives them points and helps others know it was a correct answer. If members know you'll accept an answer, they'll be more likely to spend time on your next question(s).