Populate listbox from SQL

[macdaddy]

Good morning,

I'm trying to modify an existing zenon 6.22 project which uses a listbox to select a product number and send a corresponding integer value to the hardware which tells the machine which product is in production.

Currently the Product numbers and integers are hard coded into the listbox values and I would ideally like to make this dynamic from a SQL database to allow for new products.

I have written some VBA code to query the database but I cannot see how I can use the returned data to populate the listbox. Could somebody point me in the right direction please?

Best regards,

Paul

[macdaddy]

I've just found this entry in the help files for combo/list boxes:

Not supported are dynamic behavior and the linking of macros to element-events (e.g. LeftClickUp…)

Does that mean that what I'm trying to do is pretty much impossible or is it refering to something else?

Paul

[herberto]

Please check out following thread : http://www.copadata.com/forums/showthread.php?t=526

Regards,
Herbert