Advantech ADAM-5560 user manual SQL Function Block Reference AdvSQLInit

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.

ADAM-5560 Series User Manual 146