SQLite Query Statement (Obsolete)

<< Click to Display Table of Contents >>

Navigation:  Hardware Modules > aMG SQLite Database Server > Waijung simulink block support >

SQLite Query Statement (Obsolete)

Previous pageReturn to chapter overviewNext page

(Obsolete block)

User Interface

How this block appears in a Simulink model?

amgsqlite_block2

What can be configured?

amgsqlite_mask2

Configuration item

Selectable option/ Value

Description

Statement

INSERT | UPDATE | SELECT

INSERT - Store new new data row into a specified table.

UPDATE - Update data

SELECT - Get data from data in a specified table with specific condition.

SQLite table (file)

(Select available table, from SQLite Table Setup block)


Customize columns

Checked | Unchecked

Enable or Disable customize select only some column in a table.

Columns

-

List of columns to process with SQLite statement.

Query Format

-

Display string format to sent via UART for SQLite processing.

Sample time (sec)

(Sample time)

Specify block sample time.

Demo

1. Basic UART-SQLite query demo

2. Use Waijung Blockset for SQLite data logger demo