SQL stands for Structured Query Language. SQL lets you access and manipulate databases. This function is to run SQL command such as Insert, Delete, Update and so on.
How to run SQL
Create a new behavior. Put the appropriate caption. Click Action wizard.
Click Create an action.
Click Run SQL command.
Select a datasource and input your SQL command to run. Click OK.
Click Save changes.
Click View code to see the code. Click Save and close.
Click Create now.
Example how it look in the form:
Before
After
Kindly notice the item 'test' has been updated to 'Utilities'.
Comments