Dear Colleagues,
how can I show the content on the HMI screen the content of a SQLite database which located on USB or SD-card memory?
There is a special control DatabaseViewer in the iX Developer. The embedded control option shows the internal memory area only. How to inform about (or find) an external database?
regards, Waldemar
How to show data from external Database?
Re: How to show data from external Database?
I found one solution.
Unfortunately, where is no DataGridView control (like one in Visual Studio) in iX Developer. It looks like, that DatabaseViewer is something similar with restricted functionality?
To monitor the external database, some actions were required.
In the internal database Database.db I created a table with similar structure like one in the external database I want to monitor.
Next, attached the external database. Then, during the same transaction, using "INSERT..SELECT" command, populated the new table with data from the external database.
Now the DatabaseViewer control can be used for monitoring the data chosen.
Why the DatabaseViewer can't see direct the external database, in not clear for me?
Unfortunately, where is no DataGridView control (like one in Visual Studio) in iX Developer. It looks like, that DatabaseViewer is something similar with restricted functionality?
To monitor the external database, some actions were required.
In the internal database Database.db I created a table with similar structure like one in the external database I want to monitor.
Next, attached the external database. Then, during the same transaction, using "INSERT..SELECT" command, populated the new table with data from the external database.
Now the DatabaseViewer control can be used for monitoring the data chosen.
Why the DatabaseViewer can't see direct the external database, in not clear for me?