[Date Prev][Date Next][Thread Prev][Thread Next]
[Author Index] [Date Index] [Thread Index]
[SQR-USERS Info] [SQRUG Home Page]

RE: [sqr-users] Error encountered

Good morning,
Instead of using the LET command try using the MOVE command.

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