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.
The link https://www.indi-an.com/help_quickhmi/actual/online/en/creating_database_ds.html
is not working.
For some reason there was a closing bracket ")" in the link. This links works:
https://www.indi-an.com/help_quickhmi/actual/online/en/creating_database_ds.html
Although we suggest using the new documentation as the old "classic" one will no longer be maintained: https://docs.quickhmi.com/en/dokumentation/communication/create-database-data-sources/
