Insert into SQL database

[Former Member]

Hi,

I am using xMII v 11.5..I need to insert into SQL database.

In BLS

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...

Regards

Sweety

Edited by: sweety_VA on Apr 25, 2011 7:32 AM

[agentry_src]

Hi Sweety,

Can you provide some more information?

The script for each of your queries. (looking especially at how you are using single quotes around the Param properties for different data types)

Are you using an Command SQL Query for the insert?

Why are you using the Calculation action block instead of using the Expression Editor for the calculation?

Regards,

Mike

[Former Member]

Hi Mike,

Sorry for the delay....

Its working fine now....I think the problem was in the java version...

Thank you

sweety