hello,
Using TIA V16 WinCC Advanced. I'm looking to feed a combobox with values from a SQL server database using VBS. I can connect and get the data, but how can I feed the control? Is it possible to do it using VBS? I read something about dynamic list, but nothing using data from a database.

I cannot create a static list, values from the DB is unknown (data is pulled from WMS system).

Goal is to let operator select carrier and assign shipping door at a distribution center.

thanks for your time and help

Hello,

The comboBox could linked with integer tag.with fixed string.

you can define 10 tables in your SQL database and connect to the table with the number which the combo box pointer on it.

Hello,

Dynamic text lists can be done but always through variables as indicated in the FAQ: Dynamic text lists in WinCC Comfort/Advanced you have to directly attack the properties of the list to insert values read in the SQL is not possible since it does not support this dynamization, in script, in an Advanced.

You could, via script, read these values from the SQL and store them in variables that are used in the dynamic list.