SQL variables allocation problem

SQL variables allocation problem

Hello Zenon Team!
I'm designing a project with Zenon, and we are exploring some features.
We need to write on sql data base some variables values. We are doing it by the "allocation" method.
We have done the following steps:
1- We created the data base and the tables wich will receive the values from variables, like described in "SQLDRV drive.pdf".
2- Then on the editor we configured the odbc connection and it was successfull.
3- We defined two variables: varInt1 (internal variable) and varSQL1 (sql variable) with the same data type.
4- we created an allocation between this two variables (varInt1-> varSQL1) with an edge trigger defined.
5- Finally we runned the test project, we changed the value of internal variable and then activated the trigger, nothing was written on SQL tables.
Anyone has experience on this field and coul help us with some information, tutorial.....whatever!
Thanks in advance,
rloureiro

This is a migrated post! Originally posted on 12.03.2008 by user rloureiro. Please be aware that information can be outdated.