Questions

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

Strange Issue with Stored Procedure and DeleteCommand

Answer Accepted
I have a strange issue in my XMP Template where in my DeleteCommand, while utilizing a Stored Procedure, I get an error telling me that the SP is expecting a parameter that I am providing. Yet when I change the Command Text to a straight forward DELETE statement, it works fine with the parameter. See Fiddle: http://dnndev.com/fiddle/fid/744 Also if I run the SP manually in SSMS, it executes withou
DeleteCommandstoredprocedure
0 votes
1 responses
1157 views
Steve Krantzman asked Jan 30, 2019 active Feb 8, 2019

Form SelectCommand Stored Procedure Parameters not working

In an AddForm I am unable to call a stored procedure in a Select Command as commandtype="storedprocedure" as follows: <SelectCommand CommandText="GetAddCodeChangeDefaults" CommandType="StoredProcedure" ConnectionString="*" > <Parameter Name="LoggedOnUserID" Value='[[User:ID]]' DataType="Int32" Size="100"/> </SelectCommand> The above throws an error stating that the Parameter was not supplied. I ha
parameterSelectCommandstoredprocedure
0 votes
3 responses
2818 views
Phillip Austin asked Jul 10, 2014 active Dec 22, 2016

Error on call to Update Stored Procedure

I am getting an error on my first stored procedure XMod Pro EditForm. The stored procedure is being called and it is updating correctly. However, the XMOD Form is giving me the error: Error MESSAGE: An item with the same key has already been added. STACK TRACE: at KnowBetter.XModPro.FormFunctions.UpdateButtonClicked(XItem& xi) at KnowBetter.XModPro.XModPro.frmAddRecord_UpdateButtonClicked(FormEven
storedprocedure
0 votes
6 responses
3022 views
Roberts Hunter asked May 21, 2013 active May 21, 2013

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).