RE: [sqr-users] Error encountered

["Angelika Scheffera" <angelika_scheffera@msn.com>]

Did you try the MOVE command instead of the LET?

Replace:
LET #COUNT = &COUNTTMR
LET $COUNT = ROUND(#COUNT,0)

With:
MOVE &COUNTTMR TO #COUNT
LET #COUNT = ROUND(#COUNT,0)
MOVE #COUNT TO $COUNT

Kind regards,
Angelika

-----Original Message-----
From: sqr-users-bounces+angelika_scheffera=msn.com@sqrug.org
[mailto:sqr-users-bounces+angelika_scheffera=msn.com@sqrug.org] On Behalf Of
Vaidyanathan, Ramakrishnan (GE, Corporate,consultant)
Sent: Monday, October 16, 2006 9:26 AM
To: This list is for discussion about the SQR database reportinglanguage
fromHyperion Solutions.
Subject: RE: [sqr-users] Error encountered

hi all,

        Even after using to_char function Iam getting the same error.

Thanks
Ram

-----Original Message-----
From: sqr-users-bounces+ramakrishnan.vaidyanathan=ge.com@sqrug.org
[mailto:sqr-users-bounces+ramakrishnan.vaidyanathan=ge.com@sqrug.org]On
Behalf Of Bob Helm
Sent: Monday, October 16, 2006 10:07 AM
To: This list is for discussion about the SQR database reportinglanguage
fromHyperion Solutions.
Subject: RE: [sqr-users] Error encountered


I think it's in the LET $COUNT = ROUND(#COUNT,0) line.

Maybe try LET $COUNT = to_char(ROUND(#COUNT,0))



-----Original Message-----
From: sqr-users-bounces+bob.helm=mediware.com@sqrug.org
[mailto:sqr-users-bounces+bob.helm=mediware.com@sqrug.org]On Behalf Of
Vaidyanathan, Ramakrishnan (GE, Corporate,consultant)
Sent: Monday, October 16, 2006 9:00 AM
To: sqr-users@sqrug.org
Subject: [sqr-users] Error encountered


Hi All,

        Iam getting the following error when i execute the below code
        Error - 
        (SQR 6006) String 2Em -  String To Decimal Object Conversion Error 


        Code -

        BEGIN-SELECT
        COUNTM &COUNTTMR
        LET #COUNT = &COUNTTMR
        LET $COUNT = ROUND(#COUNT,0)
        !Others,Matchingrows,302635
        Let $WRITE_SUM_LINE = 'Others' ||'^'||'Matchingrows'|| '^' || $COUNT
        Write 99107 From $WRITE_SUM_LINE
        FROM
        (
        SELECT COUNT(1) COUNTM
        FROM PS_GE_QA_CMP_LINE_DTL
        WHERE DRIVER_CODE = $upp_filepath
        )
        END-SELECT


Thanks in Advance
Ram

_______________________________________________
sqr-users mailing list
sqr-users@sqrug.org
http://www.sqrug.org/mailman/listinfo/sqr-users


_______________________________________________
sqr-users mailing list
sqr-users@sqrug.org
http://www.sqrug.org/mailman/listinfo/sqr-users

_______________________________________________
sqr-users mailing list
sqr-users@sqrug.org
http://www.sqrug.org/mailman/listinfo/sqr-users


_______________________________________________
sqr-users mailing list
sqr-users@sqrug.org
http://www.sqrug.org/mailman/listinfo/sqr-users