Maximum Function Arguments in a Query?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am using a query to do some imported data validaton. All was well. I had
to add some additional business rules which increased the number arguments I
need to pass to the function to validate. I have 12 arguments and I get this
error:

Wrong Number of Arguements used with function in query experession
Error number is 3075

I have confirmed the number of arguments in the query match the number in
the function. I am assuming there is a maximum. Does anyone know what it is?
 
If there is a limit, I'm pretty sure it's higher than 12.

What's the declaration for the function, and what does your statement trying
to invoke the function look like?
 
Boy, do I feel stupid!
I was assembling the call and the declaration to send and realized that
during the copy/paste from the current version to the new, I had neglected to
rename the function call in the query. It was calling the original query
with a different name and few arguments. I fixed it and it works.

Must be Friday.

Thanks, Douglas.
 
I got 29, but John Spencer pointed out that using a parameter array he could
get 60 with no problems

(david)
 
29 seems a strange limit! Wonder if the type of parameter matters... (Too
lazy to test it out myself)
 
Seems like I remember something about 29 being a limit. I also considered a
parameter array, but before I got there, I realized it was Friday afternoon
and my brain had already left for the day.

I made copies of the original function and the original query to try to
improve performance. I, of course, renamed the function so there would be no
name conflict, added 5 parameters to the query, and modified the function to
use the new parameters. What I did not do was change the name of the
function in the query, so it was calling the original function name which had
fewer parameters.

All I had to do was call the correct function and everything is fine.
 
Back
Top