DevForce Community Forum : Stored Procedure with output parameter? http://www.ideablade.com/forum/ This is an XML content feed of; DevForce Community Forum : DevForce 2010 : Stored Procedure with output parameter? Wed, 13 May 2026 12:26:27 -700 Wed, 18 Jan 2012 12:52:59 -700 http://blogs.law.harvard.edu/tech/rss Web Wiz Forums 9.69 360 www.ideablade.com/forum/RSS_post_feed.asp?TID=3219 DevForce Community Forum http://www.ideablade.com/forum/forum_images/IdeaBlade_logo_tm.png http://www.ideablade.com/forum/ Stored Procedure with output parameter? : Hi katit,StoredProcs with out... http://www.ideablade.com/forum/forum_posts.asp?TID=3219&PID=12483#12483 Author: DenisK
Subject: 3219
Posted: 18-Jan-2012 at 12:52pm

Hi katit,

StoredProcs with out parms is supported starting version 6.1.2. See the following release notes for more details. Look for F1703.

http://drc.ideablade.com/xwiki/bin/view/Documentation/612-release-notes#HNewandimprovedproductfeatures

To access the output parameters when doing async query, use StoredProcQuery.Parameters list. So in your case, it will be something like this.

           StoredProcQuery query = this.EntityManager.SYSGetNextNumberQuery("MobileTrip", nextTripNumber);
            var entityQueryOperation = this.EntityManager.ExecuteQueryAsync(query);
            entityQueryOperation.Completed += (s, args) =>
            {
                if (args.CompletedSuccessfully)
                {
		    nextTripNumber = query.Parameters[1].Value;
                    onSuccess(nextTripNumber.Value);
                }
                else
                {
                    args.MarkErrorAsHandled();
                    onFail(args.Error);
                }
            };


]]> Wed, 18 Jan 2012 12:52:59 -700 http://www.ideablade.com/forum/forum_posts.asp?TID=3219&PID=12483#12483 Stored Procedure with output parameter? : Is that supported? This... http://www.ideablade.com/forum/forum_posts.asp?TID=3219&PID=12477#12477 Author: katit
Subject: 3219
Posted: 17-Jan-2012 at 6:57pm

Is that supported? This is code I have (what I found in documentation) but seems like I can't get parameter out. Right? What choices do I have?
 
public INotifyCompleted GetNextTripNumber(Action<int> onSuccess = null, Action<Exception> onFail = null)
        {
            int? nextTripNumber = 0;
            var query = this.EntityManager.SYSGetNextNumberQuery("MobileTrip", nextTripNumber);
            var entityQueryOperation = this.EntityManager.ExecuteQueryAsync(query);
            entityQueryOperation.Completed += (s, args) =>
            {
                if (args.CompletedSuccessfully)
                {
                    onSuccess(nextTripNumber.Value);
                }
                else
                {
                    args.MarkErrorAsHandled();
                    onFail(args.Error);
                }
            };
            return entityQueryOperation;
        }


Edited by katit - 17-Jan-2012 at 6:58pm]]> Tue, 17 Jan 2012 18:57:46 -700 http://www.ideablade.com/forum/forum_posts.asp?TID=3219&PID=12477#12477