Login ProductsSalesSupportDownloadsAbout |
Home » Technical Support » ElevateDB Technical Support » Support Forums » ElevateDB SQL » View Thread |
Messages 1 to 3 of 3 total |
Parameter values cleared when using same parameter names in calling function |
Wed, Sep 19 2018 9:59 AM | Permanent Link |
Mike | When a function (F2) from within another function (F1) is called with same parameters the parameter values within F1 seems to be reset.
Function F1 parameters OrderID, SectionID Function F2 parameters OrderID, SectionID The parameter values are used in function F1 for further processing. SET StatusCount=F2(OrderID, SectionID); After this statement the value of SectionID is 0 while it was first > 0. I have solved it now by using a temporary variable with SectionID value but is this a bug or normal behaviour? |
Wed, Sep 19 2018 10:29 AM | Permanent Link |
Fernando Dias Team Elevate | Mike,
Can we have the complete function headers please? -- Fernando Dias [Team Elevate] Às 14:59 de 19/09/2018, Mike escreveu: > When a function (F2) from within another function (F1) is called with same parameters the parameter values within F1 seems to be reset. > > Function F1 parameters OrderID, SectionID > Function F2 parameters OrderID, SectionID > > > The parameter values are used in function F1 for further processing. > SET StatusCount=F2(OrderID, SectionID); > > After this statement the value of SectionID is 0 while it was first > 0. > > I have solved it now by using a temporary variable with SectionID value but is this a bug or normal behaviour? > |
Wed, Sep 19 2018 10:59 AM | Permanent Link |
Mike | Fernando,
Never mind. Function F2 was missing the parameter SectionID Thanks for the quick reply. |
This web page was last updated on Tuesday, April 30, 2024 at 03:55 PM | Privacy PolicySite Map © 2024 Elevate Software, Inc. All Rights Reserved Questions or comments ? E-mail us at info@elevatesoft.com |