You are viewing limited content. For full access, please sign in.

Question

Question

Lookup Rule Stored Procedure Parameter Ordering

asked on November 26, 2015

I've just installed Forms version 10 and started some development work on a form.  I've already come across a small issue using Lookup Rules.  I'm not sure if it specific to v.10 or not.  When I initially set up a lookup rule that utilized a stored procedure with 3 parameters it listed the parameters in the wrong order.  It took me a bit to figure out what the issue was.  I ended up recreating the lookup rule and the second time it put the parameters in the correct order.  Nothing had changed with the stored procedure.

I noticed that the lookup rule calls the stored procedure using parameters in order without using the parameter name in the call.  I'm not sure why this was done, but I think using the parameter name in the call would be a better practice.  If a developer reorders the parameters in a stored procedure without making any other changes this will break a Forms Lookup Rule.  I'm curious what others think.  Should this be an enhancement request?

Info from Microsoft: https://technet.microsoft.com/en-us/library/ms177436(v=sql.105).aspx


Values can be passed to stored procedures either by explicitly naming the parameters and assigning the appropriate value or by supplying the parameter values given in the CREATE PROCEDURE statement without naming them. For example, if the stored procedure my_proc expects three parameters named @first, @second, and @third, the values passed to the stored procedure can be assigned to the parameter names, such as:


EXECUTE my_proc @second = 2, @first = 1, @third = 3;

Or by position without naming them:


EXECUTE my_proc 1, 2, 3;


Naming the parameters when executing the stored procedure allows the parameters to be supplied in any order.

0 0

Answer

SELECTED ANSWER
replied on January 5, 2016

This issue is addressed in Laserfiche Forms 10 Update 1

0 0

Replies

replied on November 30, 2015

Hi there,

We are able to reproduce the issue you reported, will get it fixed in next version.

1 0
replied on December 1, 2015

Thanks for the speedy response Abby.   Hopefully this doesn't cause too much of an impact before it can be fixed.

0 0
You are not allowed to follow up in this post.

Sign in to reply to this post.