VBScript
VBScript function enables reading, writing, and manipulating the data that belongs to any of the connected data sources.
About group identifies the function.
-
Name: function ID, initially defined by the function type.
-
Description: function's purpose and role as defined by the user.
-
Function type: show which type of scripting is selected.
VBScript group allows defining the script.
-
Insert data source: inserts an existing or a newly created data source into the script.
-
Verify: validates the entered script syntax.
-
Script editor: opens the editor which makes scripting easier and more efficient.
Note
The result of the script must be saved in the 'Result'. The value of 'Result' is inserted into the name of the function. Such function is available as a dynamic data source for further use.
Example 39. Example:
The variable NAME provides the first and last name of a person. VBScript function should break the names apart and use only the first name as the result of the function.
NAME variable initial value: John Doe
Dim Spc
Spc = InStr(NAME, " ")
if NAME <> "" then
Result = Mid(NAME, 1, Spc-1)
end if
Result of VBScript: John
Note
To verify if a date variable is empty, use the syntax:
Datevariable.Value == None
more