Transfer data with JavaScript
Note that you can use the database actions defined in "Database actions" even from the JavaScript code as for the below examples:
function myButton1_onMouseClick(me, eventInfo) {
var CustomSQL = '' ;
var DatabaseLink ='Link1';
project.dbInit(DatabaseLink, CustomSQL);
};
function myButton2_onMouseClick(me, eventInfo) {
var CustomSQL = '' ;
var DatabaseLink ='Link1';
var Tags ='Alarm1;SystemTime;Tag01;Tag02;';
project.dbReadTags(DatabaseLink, CustomSQL, Tags);
};
function myButton3_onMouseClick(me, eventInfo) {
var CustomSQL = '' ;
var DatabaseLink ='Link1';
var Tags ='Alarm1;SystemTime;Tag01;Tag02;';
project.dbWriteTags(DatabaseLink, CustomSQL, Tags);
};
dbQuery
project.dbQuery(databaseLink, customSQL, dbCallback);
Using this query you can execute SQL Queries.
| Parameter | Description |
|---|---|
| databaseLink | Link to the database to use |
| customSQL | String with the SQL query |
| dbCallback() | Function that will be call when query data are ready |
dbCallBack
project.dbCallBack(dbStatus, dbResponse);
| Parameter | Description |
|---|---|
| dbStatus | See the below errors list. |
| dbResponse |
Query response. Table column names followed by its rows: In the example: TagnName - Tagvalue |
Error codes
| dbStatus | Description |
|---|---|
| 0 | SQL_NO_ERROR |
| -1 | SQL_ERROR |
| -2 | SOCKET_COMM_ERROR_CMD_READ |
| -3 | SOCKET_COMM_ERROR_CMD_VALUE_READ |
| -4 | SOCKET_COMM_ERROR_CMD_STR_DIFF |
| -5 | SOCKET_COMM_ERROR_CMD_READ_RS |
| -6 | SOCKET_COMM_ERROR_CMD_VALUE_READ_RS |
| -7 | SOCKET_COMM_ERROR_CMD_STR_DIFF_RS |
| -9 | SOCKET_COMM_ERROR_CMD_READ_RR |
| -10 | SOCKET_COMM_ERROR_CMD_VALUE_READ_RR |
| -11 | SOCKET_COMM_ERROR_CMD_STR_DIFF_RR |
| -12 | SOCKET_COMM_ERROR_CMD_READ_RC |
| -13 | SOCKET_COMM_ERROR_CMD_VALUE_READ_RC |
| -14 | SOCKET_COMM_ERROR_CMD_STR_DIFF_RC |
| -15 | SOCKET_COMM_ERROR_CMD_READ_RN |
| -16 | SOCKET_COMM_ERROR_CMD_VALUE_READ_RN |
| -17 | SOCKET_COMM_ERROR_CMD_STR_DIFF_RN |
| -18 | SOCKET_COMM_ERROR_READ_STR_RN |
| -19 | SOCKET_COMM_ERROR_CMD_READ_RD |
| -20 | SOCKET_COMM_ERROR_CMD_VALUE_READ_RD |
| -21 | SOCKET_COMM_ERROR_CMD_STR_DIFF_RD |
| -22 | SOCKET_COMM_ERROR_READ_STR_RD |
| -23 | SOCKET_COMM_ERROR_STRING_SIZE |
| -24 | SQL_WRITE_ERROR |
| -25 | SOCKET_COMM_ERROR_CREATE_SOCKET |
| -26 | SQL_ERROR_READ_TAG_FROM_ENGINE |
| -27 | SQL_DB_WRITE_TAG_INSERT_NOT_TRIED |
| -28 | SQL_DB_WRITE_TAG_UPDATE_NOT_SUCCESS |
| -29 | SQL_ERROR_READ_TAG_NAME_COL_NOT_FOUND |
| -30 | SQL_ERROR_READ_TAG_VALUE_COL_NOT_FOUND |
| -31 | SQL_ERROR_READ_TAG_NOT_FOUND |
| -32 | SQL_ERROR_GROUP_READ_FROM_ENGINE |
| -33 | SQL_ERROR_GROUP_NOT_FOUND |
| -34 | SQL_ERROR_GROUP_READ_CHUNK_MISSED |
| -35 | SQL_ERROR_TREND_READ_FROM_ENGINE |
| -36 | SQL_ERROR_EVENT_READ_FROM_ENGINE |
| -37 | SQL_ERROR_EVENT_INIT_PARAMS |
| -38 | SQL_ERROR_RECIPE_READ_FROM_ENGINE |
| -39 | SQL_DB_WRITE_RECIPE_UPDATE_NOT_SUCCESS |
| -40 | SQL_DB_WRITE_RECIPE_INSERT_NOT_TRIED |
| -41 | SQL_ERROR_RECIPE_NOT_FOUND |
| -42 | SQL_ERROR_READ_RECIPE_NAME_COL_NOT_FOUND |
| -43 | SQL_ERROR_READ_RECIPE_SET_COL_NOT_FOUND |
| -44 | SQL_ERROR_READ_RECIPE_ELEMENT_COL_NOT_FOUND |
| -45 | SQL_ERROR_READ_RECIPE_VALUE_COL_NOT_FOUND |
| -46 | SQL_ERROR_READ_RECIPE_ELEMENT_NOT_FOUND |
| -47 | SQL_ERROR_RECIPE_READ_CHUNK_MISSED |
| -48 | SQL_EVENT_TREND_ERROR_NO_DATA |
| -49 | SQL_ERROR_TRENDEVENT_SAMPLE_SQL_ERROR |
| -50 | SOCKET_COMM_ERROR_CMD_VALUE_READ_AR |
| -51 | SQL_DB_WRITE_TAG_EMPTY_GOOD_QUALITY_TAGS |
| -52 | SQL_ERROR_READ_TAGS_WRITE_TO_ENGINE_FAILED |
| -53 | SQL_DB_WRITE_TAG_FAILED |
| -54 | SQL_DB_GROUP_TAGS_NOT_FOUND |
| -55 | SQL_DB_WRITE_RECIPE_INSERT_FAILED |
| -56 | SQL_ERROR_READ_RECIPE_WRITE_TO_ENGINE_FAILED |
| -200 | QT_SQL_ERROR Check “Database link error message” system variable for more details. (See Database variables in "Default variables"). |
| -300 | DB_CONNECTOR_LICENSE_EXPIRED |