[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


Check the archives.

Richard Knapp
AITS - Reporting
University of Missouri
Locust Street Building
Columbia, MO 65201
573-882-8856
knappr@umsystem.edu

-----Original Message-----
From: sqr-users-bounces+knappr=umsystem.edu@sqrug.org
[mailto:sqr-users-bounces+knappr=umsystem.edu@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