How Do I? | Forum | Realisable

Back to forum list… Back to How Do I?...

Field references in common functions (1 reply and 1 comment)

Steve Bagnall

4 years ago

Steve Bagnall 4 years ago

As far as I understand, field references (eg: %cust_id) can't be used in common function script.

If that's correct, does anyone have suggestions on storing code snippets for re-use as functions where field references are required in the code?

A simplified example of a required function is

Function Create_GL_Code(sType)
Dim sCode
Select Case Lookup("Trans1","FLD02",%transaction_type_id,true)
Case "01" sCode = Lookup("Defaults","FLD01",1,true)&"."&%client_id
Case "02" sCode= Lookup("Defaults","FLD02",1,true)
End Select
Create_GL_Code = sCode
End Function

Support

4 years ago

Support 4 years ago

Use the GetValue function instead.

Function Create_GL_Code(sType)
Dim sCode
Select Case Lookup("Trans1","FLD02", GetValue("transaction_type_id") , true)
  Case "01" sCode = Lookup("Defaults","FLD01",1,true) & "." & GetValue("client_id")
  Case "02" sCode= Lookup("Defaults","FLD02",1,true)
End Select
Create_GL_Code = sCode
End Function

Steve Bagnall

4 years ago

That's wonderful. I never thought of trying it that way
Thanks.

Field references in common functions (1 reply and 1 comment)

Contact

Request Demo

Access Downloads

Username
Password

	Remember Me Lost your password? Register