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

[MOHANLAL]

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 

[FredrikV]

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.

[MOHANLAL]

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?

[ursulak]

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.