BSL Function with Parameter

Answered

Gus Ojeda

• September 02, 2020 19:21

We are trying to create a BSL function passing 2  parameters.

There seems to be missing or wrong information on the Online Help and the Tutorial video on youtube. 

1. Example of a Function with parameters is missing. 

http://www.beascloud.net/docs/help/bsl/bslcustomizing.htm 

 

We are able to create the register Functions Parameters, but BSL does not allow to include the data type in the format described in the documentation:

ParameterName/type,ParameterName/type

The field type:

c=char

i=integer/numeric

d=date

b=boolean

 

Example

Color/c,Width/i

 

When added in this format, BSL seems to consider the datatype as part of the name of the parameter

 "Syntax error. Function CompanyWorkOrderActivity/FExample1(Parameter1/c,Parameter2/c):  Parameter Parameter1/c: only Char is allowed. Value is type 

 

 

 

2. If we don't specify the parameter type, BSL accepts the parameter and executes the function. We have tried different ways to use the BSL parameter but can't use this on a query within the function.

 

[register CompanyWorkOrderActivity]
........
function=name=CountOfEntries<tab>description=Return Count of existing activities
function=name=FExample1<tab>parameter=Parameter1/c,Parameter2/c<tab>description=Return something
[/register CompanyWorkOrderActivity]

 

[CompanyWorkOrderActivity/FExample1]
sql=select "ADM1"."City" into result from "ADM1" where "ADM1"."City"=<Parameter1>
[/CompanyWorkOrderActivity/FExample1]

 

Does anyone have an example of BSL Function with parameters ?

Vote

0

• Official comment

  

  Martin Heigl

  • September 29, 2020 05:42

  Hi,

  if you activate the debug log, you can see more

  I see follow error: You must convert the Parameter in database string

  sql=select "ADM1"."City" into result from "ADM1" where "ADM1"."City"=<Parameter1,dbstring>

Please sign in to leave a comment.