SQL_EXECUTE Function
Function Type | Predefined function | |
Syntax | SQL_EXECUTE( <table>, <stringSQLStatement> ) | |
Description | Executes an SQL statement against the database where the <table> resides. | |
Argument | Description | |
<table> | Table in the database where the SQL statement will be executed. | |
<stringSQLStatement> | String containing the SQL statement to be executed. | |
Returns | Boolean true = SQL statement executed successfully | |
Example | This example executes an SQL expression against the database that Source.Table1 resides in. In this example, all of the records in Table1 are deleted. Returns "true" if the call was successful, otherwise "false". SQL_EXECUTE(Source.Table1,"delete * from Table1") | |
Tip: For faster searching, add an asterisk to the end of your partial query. Example: cert*