Sybase SP's and CR

[vrushal]

This is an interesting issue I did like you to look into.
I am using Sybase 12.5 client and Sybase 12.0 as my server.
I am using Sybase Native Drivers to in my Crystal Report to connect to the Sybase Db.
My problem is when I join 2 SP's the report does not display the proper record set.It returns only 1 record instead of 3 records.
As a matter of fact one of the 2 records that it does not return is the same as the one which it returns.

The same join works very well using ODBC which we don't want to use.

The query is as given below :
create PROCEDURE select_nv_gtt_tws_pmcustomer

AS

declare @spError integer,

@spRowcount integer

BEGIN



SELECT tradingCustomerID,

customerName,

reutersCode,

inUse,

customerDDA,

pmtsId,

shortName

FROM TWSPMCustomer

WHERE inUse = 'Y'



select @spError = @@error

IF @spError != 0

BEGIN

RAISERROR 35001 "Unable to select from TWSPMCustomer"

RETURN

END

RETURN

END

This query whenever is joined any other query returns only 1 record.

I have downloaded the latest service pack available on crystal decisions website and the version of the crdb_p2ss8.dll is 9.2.0.177.

I have a deadline to meet and this has become a major bottleneck for several reports of mine.

-Thanks and Regards ,
Vrushal Deshpande
E-Mail : vrushald@quinnox.com