Skip to Content
avatar image
Former Member

Insert into SQL database

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

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Apr 25, 2011 at 11:28 AM

    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

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member

      Hi Mike,

      Sorry for the delay....

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

      Thank you

      sweety