New List using SQLite

<< Click to Display Table of Contents >>

Navigation:  PlantExpressTools > How to use > Update Selection Lists > Setup >

New List using SQLite

Previous pageReturn to chapter overviewNext page

In this example we use a SQLite database with the table "Media Color". This is actually from a Danish customer.

Selection Lists 34

We open the main dialog again.

Selection Lists 01

We see the configuration of the previous chapters. Make sure they are all disabled before continuing.

Selection Lists 35

This type we use "SQLite database files (*.db;*db3;*.sqlite)" and select our sample file.

Selection Lists 36

We adapt the path as in the previous chapters.

Databases can have tables and views (or queries). In our example there is just one table, so we select "Tables" and then select the table itself.

We then see all columns from our table.

Selection Lists 37

We select "Service" and "Description" and the Category settings as before.

Selection Lists 38

We see the new line.

Selection Lists 39

We update the Selection List.

Selection Lists 16

We get the result.

Selection Lists 17

When we check we see the content from our SQLite table.

Selection Lists 40

Next Chapter: New List using MS Access