Back to Database PlugITs content page

"SQLite" PlugIT

The "SQLite" PlugIT allows to create and manage a SQLite database and to associate it requests that can be then called by other PlugITs.

 

Parameters

1

Path to the database file.

2

If checked, the database will not be saved in the hard drive. It will only stays in the RAM while the application runs.

3

If checked, use UTF-8 format for the database.

4

Field for the initialization script of the database.

5

List of the SQL requests associated with the database. Each request create an action and an event with the same name for the PlugIT.

6

Entry field for the selected SQL request code.

7

Format of the message sent as output after a call to the selected request. You can call variables with a $ before the name of the variable (example : $MyVar).

8

New : Adds a new SQL request to the list.
Rename : Rename the selected SQL request
Delete: Delete the selected SQL request


 

Action

Exec "X"

Execute the "X" SQL request.

Exec

Execute the SQL request given in the link parameter.

Change database

Changes the database used by the one given in the link parameter.


 

Event

Result "X"

Triggered when the "X" SQL request is executed. Contain the result of the request, formatted as described in the "Output format" field.

Result

Triggered when a SQL request given in the link parameter is executed. Contain the result of the request.

Database loaded

Triggered when the database has been loaded.