show SQL database in a table in WebIQ

[David08]

Hello webiq-eg,

I have a customer who wants to display a sql table in WebIQ, and by selecting a row he can write a data directly to the external MS SQL database.
To display the table I would also need a Query to request the data.
Would this be possible with Scripts and UI-Actions?

Thanks

[webiq-sk · Accepted solution]

@David08 This would better have been a new topic instead of replying to a resolved one.

First of all you need to know that it is impossible to access SQL databases directly from a web browser - web technology does not allow that in general - so this has always be done in the backend which in this case is WebIQ Server.

You currently cannot extend WebIQ Server yourself, you can however use the API to acess data stored in the local SQLite database. You cannot access MS SQL data from WebIQ Server, because it's not supported (not built in).

What you could do - as from what I see there's no connection between the data and the HMI itself - is to create (or use) another (existing) web application that provides this functionality that you can simply embed in the HMI using the iFrame widget. You can use any programming language you like that provides a web server for that and implement that functionality. 

[CodeShepherd]

Moved to own topic from "SQL Server".