Dynamics Community Forum Thread Details

Retrieving the next value of a sequence through a Dexterity procedure

Has any one tried getting the next value of a sequence through a stored procedure and accessing it through dexterity? I created a sequence in the database and a stored procedure to get the next value. the stored procedure works when I try it by itself.

Then in dexterity I created the procedure template where I call the stored procedure from the database using call sproc. I have the call to the procedure template in a form event.

When I tested this, the event called the procedure, but it appears some error is preventing the value from coming back. I have the value stored as a Long in dexterity, the sequence is an integer.

Does anyone know if this can be done, or is there a problem with getting a sequence value into dexterity? Or does anyone know how I can get the error from the procedure to display?

The procedure is granted execution by DYNGRP, the parameters are just the value being returned.

Well finally searched using the right terms to come up with the answer. After digging a bit more I saw that the problem was getting to the stored procedure in the first place. I was getting a stored procedure not found.

Once I figured that out I was able to search and finally got the right combination to lead me to this post:

community.dynamics.com/.../123777

A similar problem to mine, though the solution to this one was not my problem. Naga M. Siva Kiran offered the solution to my problem in a suggested answer to the post above.

The issue had nothing to do with the sequence as I had initially thought. It had to do with the Dynamics series assigned to the prototype procedure in Dexterity. I was using System (my default for some reason). Any script using System is not visible by the company database. Any other series works. I recreated the script with the Series Financial, and everything worked as expected.

So yes you can call the next value of a sequence in a stored procedure and send it back to a Dexterity form. Just be sure not to choose System for the series.

Thanks Naga!

Quick Links

Leaderboard