RE: [sqr-users] (no subject)

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

Hello, could it be that you have the end-select on your SQL.  It should be a
separate line.


Angelika M. Scheffera

 

-----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
Kaz.Narayanan@averydennison.com
Sent: Tuesday, April 17, 2007 3:52 PM
To: sqr-users@sqrug.org
Subject: [sqr-users] (no subject)

Hello,

I posted this message yesterday.
Could some one help em here?

Thanks
Regards
KM Narayanan

Hello,

I am doing a select in an SQR where we use SQL server.
My codes is as follows:

BEGIN-SELECT
A.PRODUCT 
A.ACCOUNT 
A.DEPTID 
SUM(A.POSTED_TOTAL_AMT)         &MAIN_POSTED_TOTAL_AMT

FROM PS_LEDGER A, PS_BUS_UNIT_TBL_GL A1
WHERE   A.LEDGER IN ('ACTUALS','MGMT_ADJMT')
        [$AND-CLAUSE]
        AND A.FISCAL_YEAR   = $IN_YEAR
        AND A.ACCOUNTING_PERIOD [$WHERE_PERIOD] 
        AND A.PRODUCT       <> ' '
        AND A.ACCOUNT       <> ' '
        AND A.BUSINESS_UNIT = A1.BUSINESS_UNIT
        AND ((A.CURRENCY_CD   = ' ' AND A.ACCOUNT LIKE '0%') 
        OR (A.CURRENCY_CD   = A1.BASE_CURRENCY)) 
        GROUP BY A.PRODUCT,A.ACCOUNT,A.DEPTID 
        ORDER BY A.PRODUCT,A.ACCOUNT,A.DEPTID 
END-SELECT



I get the following error when I try to execute....
SQR 5528) ODBC SQL dbftch error 3926 in cursor 30: [Microsoft][SQL Native 
Client][SQL Server]The transaction active in this session has been 
committed or aborted by another session. (SQR 5528) ODBC SQL dbftch error 
3971 in cursor 30: [Microsoft][SQL Native Client][SQL Server]Server failed 

to resume the transaction, desc: 7a00000004. Error on line 394: (SQR 3725) 

Bad return fetching row from database. 


I execute the same SQL in Microsoft SQL server studio, It works fine....
Can Someone help me?
Regards

K.M.Narayanan



- -----------------------------------------------------------------
The information transmitted is intended only for the person or entity to
which it is addressed and may contain confidential and/or privileged
material. Any review, retransmission, dissemination or other use of, or
taking of any action in reliance upon, this information by persons or
entities other than the intended recipient is prohibited. If you received
this in error, please contact the sender and delete the material from any
computer.

_______________________________________________
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