Showing results 1 to 3 of 3

Thread: Populate listbox from SQL

  1. #1
    macdaddy Gast

    Default Populate listbox from SQL

    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

  2. #2
    macdaddy Gast

    Default Re: Populate listbox from SQL

    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

  3. #3
    Join Date
    30.05.2007
    Location
    Salzburg
    Posts
    879

    Default Re: Populate listbox from SQL

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

    Regards,
    Herbert

Similar Threads

  1. MS Forms 2.0 Listbox
    By perschke in forum VBA
    Replies: 1
    Last Post: 23rd October 2009, 07:07
  2. How to populate details of alarm variables?
    By nahala in forum zenon Supervisor
    Replies: 5
    Last Post: 14th May 2009, 09:06

Posting Rules

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •