RE: [sqr-users] Hi All,

["Ian Mills" <Ian.Mills@orix.com.au>]

Steve,

Thanks for your reply. I use global variables all the time in my SQR
programs when doing temporary tables. I also have a habit of declaring
all my procedures local. I have investigated the error message returned
and it appears as though it comes from a known bug in Sybase V12. We
plan to investigate further on Wednesday morning.

Regards,
Ian Mills
ORIX Australia Pty Ltd


>>> steve.cavill@infoclarity.com.au 03/10/2003 4:36:15 pm >>>
Hi Ian,
You are using a global variable for the temp table name - is there any
chance that could contribute to the problem - are all the procedures
that
use the table name local?
Steve.

-----Original Message-----
From: sqr-users-admin@sqrug.org [mailto:sqr-users-admin@sqrug.org]On 
Behalf Of Ian Mills
Sent: Friday, 3 October 2003 3:18 PM
To: sqr-users@sqrug.org 
Subject: [sqr-users] Hi All,


Hi All,

I am getting the following error from me report. I am running against
a
Sybase database using SQR v6.1.2.

I did find a similar error posted to this user group in Sep 2001 but
noticed that nobody replied. I was wondering if anyone else more
recently has encounted this problem and remembers how they fixed it. I
would agree with the message in Sep 2001 that it is somehow related to
using a temporyary table. What makes this more confusing is that the
error does not occur when I call the procedure using "Cursor #1:"
(shown
below). If I call either "Cursor #2:" or "Cursor #3:", the error
occurs.




(SQR 5528) Sybase dbdesc: ct_results error in cursor 3:
   (5702) The SQL Server is terminating this process.


Error on line 471:
   (SQR 3722) Could not set up cursor.

SQR: Program Aborting.
(SQR 5528) Sybase ct_send error in cursor 0:
   (49) ct_send(): user api layer: external error: This routine cannot
be called because another command structure has results pending.
(SQR 5528) Sybase dblogf: ct_send (end tran) error in cursor 0:
   (49) ct_send(): user api layer: external error: This routine cannot
be called because another command structure has results pending.
(SQR 5528) Sybase ct_send error in cursor 0:
   (49) ct_send(): user api layer: external error: This routine cannot
be called because another command structure has results pending.
(SQR 5528) Sybase dblogf: ct_send error in cursor 0:
   (49) ct_send(): user api layer: external error: This routine cannot
be called because another command structure has results pending.
(SQR 5502) Cannot drop SQR generated stored procedure:
SQR_1404_1065157375.

Cursor Status:

 Cursor #1:
   SQL = SELECT les_s, name, sum(tot_rec), sum(borr_rec), sum(co_rec),
         count(distinct lse_s), count(distinct unit_s)  FROM
         [$_gs_temp_table] GROUP BY les_s ,name order by 3 desc
 Compiles = 0
 Executes = 0
 Rows     = 0

 Cursor #2:
   SQL = SELECT asset_code_desc, les_s, name, sum(tot_rec),
sum(borr_rec),
         sum(co_rec), count(distinct lse_s), count(distinct unit_s)
FROM
         [$_gs_temp_table] GROUP BY asset_code_desc ,les_s ,name order
by 1
         ,4 desc
 Compiles = 0
 Executes = 0
 Rows     = 0

 Cursor #3:
   SQL = SELECT com_s, les_s, name, sum(tot_rec), sum(borr_rec),
sum(co_rec),
         count(distinct lse_s), count(distinct unit_s)  FROM
         [$_gs_temp_table] GROUP BY com_s ,les_s ,name order by 1 ,4
desc
 Compiles = 1
 Executes = 0
 Rows     = 0


below is the create statement that creates the temporary table...
create table [$_gs_temp_table]
( com_s             char(2) NULL
 ,les_s             char(9)
 ,lse_s             char(10)
 ,unit_s            char(10)
 ,asset_code_desc   varchar(50)
 ,name              varchar(125) NULL
 ,tot_rec           float
 ,borr_rec          float
 ,co_rec            float
);


Regards,
Ian Mills
ORIX Australia Pty Ltd

_______________________________________________
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