![]() | ![]() Products ![]() ![]() ![]() ![]() |
Home » Technical Support » ElevateDB Technical Support » Support Forums » ElevateDB SQL » View Thread |
Messages 1 to 2 of 2 total |
![]() |
Fri, Dec 4 2009 8:57 AM | Permanent Link |
Roy Lambert NLH Associates ![]() | Tim
I just cocked up in my typing and typed RCF(IFNULL(M._MktDesc,IFNULL(SC._Description,SG._Description,SC._Description),M._MktDesc),O._Description+', '), rather than RCF(IFNULL(M._MktDesc,IFNULL(SC._Description,SG._Description,SC._Description),M._MktDesc),O._description,', ') note the + between the last two parameters rather than a comma. RCF (which is an SQL function) then treated the final parameter as NULL and it struck me that if I don't intend any of the parameters passed to be NULL then this could be a way of having a function with a variable number of parameters. Just stop when you hit the first NULL. Is this safe or more along the lines of "what an interesting suggestion now go and play with the nice land mines"? Roy Lambert |
Sun, Dec 6 2009 7:06 AM | Permanent Link |
Tim Young [Elevate Software] Elevate Software, Inc. ![]() | Roy,
<< Is this safe or more along the lines of "what an interesting suggestion now go and play with the nice land mines"? >> Actually, it's a bug. However, I'm considering keeping it in place because it is a nice way of doing variable parameters. I'll let you know by the next build what the decision will be. -- Tim Young Elevate Software www.elevatesoft.com |
This web page was last updated on Thursday, July 10, 2025 at 10:36 PM | Privacy Policy![]() © 2025 Elevate Software, Inc. All Rights Reserved Questions or comments ? ![]() |