Start a conversation

Executing SQL statements (Insert, Update and Delete)

With the macro macro sc_exec_sql you can execute SQL statements. Note that is useful to insert, update and delete because you dont get the output. If you need te output, use sc_lookup.

Sintax:

sc_exec_sql("SQL statement", "connection")The parameter connection is optional. 

Example:

 if(condition)

{

sc_exec_sql("UPDATE table SET field='{field_value} ' where id={field_id}");

}

Choose files or drag and drop files
Was this article helpful?
Yes
No
  1. Caio Guerra (Migrated deleted Agent)

  2. Posted
  3. Updated

Comments