BSL Function with Parameter Respondida

Gus Ojeda

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 ?

Comentarios

1 comentario

Fecha Votos
  • Comment author
    Martin Heigl
    • Comentario oficial

    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>

Iniciar sesión para dejar un comentario.