Advantech ADAM-5560 Universal Remote User Manual


 
ADAM-5560 Series User Manual 146
SQL Function Block Reference:
AdvSQL_Init
Function: Initialize SQL mobile database.
1. Enable: (BOOL), Enable AdvSQL function blocks.
2. DataBaseName: (STRING), SQL mobile database name.
3. TableName: (STRING), SQL mobile database table name.
4. ColumnTotal: (INT), Total number of fields in SQL mobile database. Maximum
number is 10.
5. PrimaryIndex: (INT) KEY Index of SQL mobile database.
6. ClearDataBase: (BOOL), Clear SQL mobile database.
AdvSQL_InsertLastData
Function: Append one record to SQL mobile database.
1. Enable: (BOOL), Enable AdvSQL function blocks.
2. DataBaseName: (STRING), SQL mobile database name. Rreserved for
handling more than one SQL mobile database in the future.
3. ColumnIndex: (INT), The column index in SQL mobile database.
4. ColumnName: (STRING), Name of SQL mobile database.
5. ValLength: (INT), Maximum length of data field.
6. Value:(STRING), Content of data field.