iX Talk

How to show data from external Database?
Page 1 of 1

Author:  wlederer [ Thu Jul 07, 2016 3:08 am ]
Post subject:  How to show data from external Database?

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

Author:  wlederer [ Fri Aug 12, 2016 1:19 am ]
Post subject:  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?

Page 1 of 1 All times are UTC - 7 hours [ DST ]
Powered by phpBB © 2000, 2002, 2005, 2007 phpBB Group