[sqr-users] ODBC SQL dbftch error

[Kaz.Narayanan@averydennison.com]

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