BlackBerry Forums Support Community               

Closed Thread
 
LinkBack Thread Tools
Old 08-07-2008, 03:36 PM   #1 (permalink)
New Member
 
Join Date: Aug 2008
Model: 8100
PIN: N/A
Carrier: Vodafone
Posts: 5
Post Thanks: 0
Thanked 0 Times in 0 Posts
Default MS SQL stored procedures in MDS App

Please Login to Remove!

Hi All

Due to the restrictions of not been able to use the percent operator in the Database Operation Designer I have created a stored procedure. When I add the SQL DB as a data source the stored procedure is picked up and the input field recognized. However the output of the procedure isn't recognized and no fields are returned with the response message. Is there any way to get MDS Studio to recognized the output response of the procedure? I have even tried the OUTPUT command in SQL but with no joy.
Offline  
Closed Thread


Thread Tools

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On

NEW JOHNSON CONTROLS SEC99AA-36
$7.0
NEW JOHNSON CONTROLS SEC99AA-36 pictureJohnson Controls Control Panel (6NOG-0140-0001)
$999.96
Johnson Controls Control Panel (6NOG-0140-0001) pictureJohnson Controls ~ Metasys DX-9100-8454 ~ Digitial Controller
$299.95
Johnson Controls ~ Metasys DX-9100-8454 ~ Digitial Controller pictureJohnson Controls ONE NEW IN BOX Model T-4506-204 THERMOSTAT Same as T-4506-6203
$99.0
Johnson Controls ONE NEW IN BOX Model T-4506-204 THERMOSTAT Same as T-4506-6203 pictureJOHNSON CONTROLS MS-CCT-0 FNFP MSCCT0
$82.0
JOHNSON CONTROLS MS-CCT-0 FNFP MSCCT0 picture






Copyright 2004-2016 BlackBerryForums.com.
The names RIM and BlackBerry are registered Trademarks of BlackBerry Inc.