To call a FlashBASIC subroutine using a pass-through query, use this syntax:
:DO-SQLSUB sub.file sub.name num.param [param1 [param2 […param16]]]
The syntax has these parameters:
| Parameter | Description |
|---|---|
| result | Indicates the completion status. Successful completion returns the string OK. |
| r1-r16 | Return results of each parameter. For example, the return column r1 contains the result of param1 after the subroutine has completed. |
| sub.file | The full path (for example, account,file,) of the file in which the subroutine exists. |
| sub.name | The subroutine name. |
| num.param | The number of parameters. |
| param1…param16 | The text values of the parameters to pass to the subroutine. These parameters are separated by spaces and should not be surrounded in quotes. |