Insert into SQL database
I am using xMII v 11.5..I need to insert into SQL database.
Step 1:I am using an SQL Query1 it fetches data
Step 2: I am using 4 calculation Action block to calculate the values
Step 3: I am inserting the Calculated values using an SQL Query2
In the links when i evaluate its showing the value but when i check in the SQL Database it has inserted zeros...
I found that the first Query is not returning anything if i have set the Date condition in where clause...
Edited by: sweety_VA on Apr 25, 2011 7:32 AM