Since I upgraded to FB 1.02 I have the following problem:

I have a Firebird stored procedure

ALTER PROCEDURE TAS_EXTRACT( PEXTRACTDATE DATE )
RETURNS ( DATA_SOURCE CHAR( 4 )
, BATCH INTEGER
, TAPE_DATE DATE
, USAGE_DATE DATE
, FG VARCHAR( 6 )
, CARRIER VARCHAR( 6 )
, NXX CHAR( 3 )
, SERVICE_CODE VARCHAR( 4 )
, JURIS VARCHAR( 5 )
, ORIG_TERM CHAR( 1 )
, MSG INTEGER
, MINUTES DECIMAL ( 18, 2 ) )
AS
BEGIN
for SELECT DATA_SOURCE
, TAPE_DATE
, USAGE_DATE
, BILL_TYPE
, CARRIER
, NXX
, SERVICE_CODE
, JURIS
, ORIG_TERM
, cast(sum(MSG) as integer) as Msgs
, cast(sum(MINUTES) as numeric(15,2)) as Mins
FROM MSGMOU
where (Billing_extract = :pExtractDate)
group by DATA_SOURCE
, TAPE_DATE
, USAGE_DATE
, BILL_TYPE
, CARRIER
, NXX
, SERVICE_CODE
, JURIS
, ORIG_TERM
Into DATA_SOURCE
, BATCH
, TAPE_DATE
, USAGE_DATE
, FG
, CARRIER
, NXX
, SERVICE_CODE
, JURIS
, ORIG_TERM
, MSG
, MINUTES

do begin
IF (DATA_SOURCE = 'AMA') THEN
DATA_SOURCE = 'DMS';
ELSE
IF (DATA_SOURCE = 'CAB') THEN
DATA_SOURCE = 'CABS';

SUSPEND;
end
END

When I call it from Paradox (or any BDE utility) using:

Select *
from TAS_EXTRACT('2/10/2003')

The minutes field of the answer table won't display because for some reason
it is of type
"Bytes". I tried changing Decimal(18,2) to Numeric(18,2) but still have the
same results. How do I get it to be a Number type in Paradox?


--

Don Gollahon