ph_directsql PowerHome formula function
Description
Execute SQL directly against the PowerHome database.
Syntax
ph_directsql ( sql )
| Argument | Description |
| sql |
String containing a valid SQL statement. Inserts, Updates, and Deletes are all valid. See ph_sqlselect to perform Selects against the database. |
Return value
Integer. Returns a 0 if the SQL was successfully executed. Otherwise a value equivalent to the SQL error when attempting to execute the SQL is returned.
Examples
The following examples demonstrate typical syntax/usage for this function.
• ph_directsql("delete from timedevents where id = 'SHOPDOOR ALERT'")