Welcome Guest ( Login | Register )



All times are UTC - 7 hours [ DST ]



Post new topic Reply to topic  [ 2 posts ] 
Author Message
 Post subject: How to show data from external Database?
PostPosted: Thu Jul 07, 2016 3:08 am 

Joined: Fri Jan 27, 2012 4:20 am
Posts: 161

Offline
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


 Profile  
 
 Post subject: Re: How to show data from external Database?
PostPosted: Fri Aug 12, 2016 1:19 am 

Joined: Fri Jan 27, 2012 4:20 am
Posts: 161

Offline
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?


 Profile  
 
Display posts from previous:  Sort by  
Post new topic Reply to topic  [ 2 posts ] 

All times are UTC - 7 hours [ DST ]


You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot post attachments in this forum

Search for:
Jump to: