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

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