codecharge_user9
Posts: 7
|
| Posted: 04/12/2005, 9:05 AM |
|
Hello.
It is 2005 now.
I saw some articles about OUTPUT parameters not being supported for Stored Procedures.
Those articles were posted in 2004.
What about now? Is this still the case?
Is there a way to custom code it? I do not mind. Just let me know where to start.
I purchased Professional Edition so that I can use Stored Procedure. I hope I can still use it.
BTW, I am not allowed to use .NET.
Thank you
|
 |
 |
smalloy
Posts: 107
|
| Posted: 04/12/2005, 1:38 PM |
|
I do not believe that it does but I have found some ways around it. I'n not sure what you need to Output but if its a recordset then you could use that recordset to populate a grid, reccord, listbox, etc.
Create the proc and insure that it contains a SELECT statement (so there's some output), then in CodeCharge select Prcedure as the Data Source Type, select the proc and you will note that all of the items within the select statement appear in the builder. 9 times out of ten you can resolve your need for OUTPUT this way.
If this is not what you are after I can send you some code on how to do it outside of a CodeCahrge control but still within the IDE where you can pass results to CodeCharge controls.
Steve
_________________
Anything can be done, just give me time and money. |
|
|
|
|
