In the sample project 100301 write_variable_from_database_table is shown the possibility to read a value from the cell of a databasetable control, through a mouse click event on the cell. Is there the possibility to get the cell value of database table pointing directly through row and col index, without using an event trigger.
Is there some other way to read variables and fields from a Table in an external DB MsSql or Mysql or ... ?
Thanks in advance
Hello frecciag,
usually to read values from a database into a variable one would use the database datasource. The downside of that is however the limitation that it can only read from one specific QHMI_VARIABLES table. ( https://www.indi-an.com/help_quickhmi/actual/online/en/creating_database_ds.html)
The extension of this function to read from any table is already on our roadmap.
To get back to your specific question in regards to the example project:
It is possible to get the cell by specifying the column and row index. We updated out demo project to reflect that.