Use the SSQL command to pass SQL commands through R:BASE to the foreign data source, where the commands will be interpreted and executed.
Options
SQLcommand
Specifies the SQL command to send.
About the SSQL Command
SSQL can be used to send structure modification commands that alter the foreign database, which are subject to the access rights and restrictions placed on the user by the foreign database.
SSQL requires R:BASE to already be connected to the data source. With a few exceptions, you can use every SQL command supported by the connected data source, such as UPDATE and DELETE.
To use commands that return data, such as the SELECT command, the command syntax is supported without the use of SSQL, but PASSTHROUGH must be set ON.
