![]() | ![]() Products ![]() ![]() ![]() ![]() |
Home » Technical Support » ElevateDB Technical Support » Support Forums » ElevateDB SQL » View Thread |
Messages 1 to 3 of 3 total |
![]() |
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 ![]() | 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 Wednesday, August 14, 2024 at 07:31 PM | Privacy Policy![]() © 2024 Elevate Software, Inc. All Rights Reserved Questions or comments ? ![]() |