Showing results 1 to 4 of 4

Thread: I need to push data from Zenon VBA to SQL database every 1sec

  1. #1
    Join Date
    07.04.2021
    Posts
    5

    Ausrufezeichen I need to push data from Zenon VBA to SQL database every 1sec

    I need to push the data of a variabe to sql data base through zenon VBA every 1sec once the runtime starts,

    I am not done much programming in VBA

    Can anyone share the programming code for this 

  2. #2
    Join Date
    18.12.2017
    Posts
    44

    Default Re: I need to push data from Zenon VBA to SQL database every 1sec

    Hi!

    You should avoid a solution based on VBA for real time operations. There is a risk that you'll block the zenon Runtime.
    Use the built in functionality like evacuation, export or the SQL-driver.

  3. #3
    Join Date
    07.04.2021
    Posts
    5

    Default Re: I need to push data from Zenon VBA to SQL database every 1sec

    Thank you for the reply

    I have done some changes in the project so everytime i execute the macro the data should pass to the sql database , this should be done in vba only as per my project requirement

    How can i do this in VBA?

  4. #4
    Join Date
    01.07.2008
    Location
    Salzburg, AT
    Posts
    1,039

    Default Re: I need to push data from Zenon VBA to SQL database every 1sec

    Do not use VBA for this, you risk that your VBA code will block the zenon runtime and your project will lose the data. As Fredrik has written: to transfer data to SQL database use zenon native available features like evacuation or export to SQL or use the SQL driver.

Similar Threads

  1. Replies: 4
    Last Post: 11th June 2021, 09:02
  2. How to use vb to push Alarm
    By utoole in forum VBA
    Replies: 0
    Last Post: 15th January 2020, 09:27
  3. Data import from other database system
    By nicolasr75 in forum VSTA
    Replies: 10
    Last Post: 28th February 2019, 07:37
  4. Replies: 2
    Last Post: 7th January 2013, 15:26
  5. SQL Database and Zenon Editor
    By bmcbrita in forum Engineering Studio & Service Engine (former zenon Editor & Runtime)
    Replies: 4
    Last Post: 2nd August 2009, 22:24

Tags for this Thread

Posting Rules

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