Home | Forums | Contact | Search | Syndication  
 
 [login] [create account]   Tuesday, May 7, 2024 
 
slxdeveloper.com Community Forums  
   
The Forums on slxdeveloper.com are now retired. The forum archive will remain available for the time being. Thank you for your participation on slxdeveloper.com!
 Architect Forums - ADO General
Forum to discuss ADO specific questions for use with SalesLogix. View the code of conduct for posting guidelines.
Forums RSS Feed


 Back to Forum List | Back to ADO General | New ThreadView:  Search:  
 Author  Thread: Error with a Command Object and a Parameter
Lou
Posts: 81
 
Error with a Command Object and a ParameterYour last visit to this thread was on 1/1/1970 12:00:00 AM
Posted: 18 Oct 06 10:17 AM
fiogf49gjkf0d
SLX v6.2

Here is the error message:

* * * * * * * * * * * * * * * * * * * * * * *
An exception of type 'MY TYPE
expects parameter 'MY PARAMETER',
which was not supplied.' was not handled.
* * * * * * * * * * * * * * * * * * * * * * *

Overall, I need to run a stored procedure, which takes one parameter. The parameter is a datetime type, and it must be in the format of yyyy-MM-dd.

Debugging confirms that I have successfully created the Command Object and populated the Parameters Collection. The error occurs when the program gets to the Execute Method.

Thoughts anyone? Let me know if any more information is needed.
[Reply][Quote]
Ryan Farley
Posts: 2265
slxdeveloper.com Site Administrator
Top 10 forum poster: 2265 posts
 
Re: Error with a Command Object and a ParameterYour last visit to this thread was on 1/1/1970 12:00:00 AM
Posted: 18 Oct 06 1:04 PM
fiogf49gjkf0d
What does the code look like? Are you executing this via the SLX provider? It doesn't exactly support stored procs.
[Reply][Quote]
Lou
Posts: 81
 
Re: Error with a Command Object and a ParameterYour last visit to this thread was on 1/1/1970 12:00:00 AM
Posted: 19 Oct 06 7:18 AM
fiogf49gjkf0d
I figured this out a little while ago after I posted. There was a sneaky typo in the CommandText!

Thanks for the attempt.
[Reply][Quote]
 Page 1 of 1 
  You can subscribe to receive a daily forum digest in your user profile. View the site code of conduct for posting guidelines.

   Forum RSS Feed - Subscribe to the forum RSS feed to keep on top of the latest forum activity!
 

 
 slxdeveloper.com is brought to you courtesy of Ryan Farley & Customer FX Corporation.
 This site, and all contents herein, are Copyright © 2024 Customer FX Corporation. The information and opinions expressed here are not endorsed by Sage Software.

code of conduct | Subscribe to the slxdeveloper.com Latest Article RSS feed
   
 
page cache (param): 5/7/2024 2:28:39 PM