Subject [IBO] possible problem IBO4.7.Beta 5 and IB_SQL
Author Hans
[IBO] possible problem IBO4.7.Beta 5 or/and IB_SQL

ALTER PROCEDURE GETTICKETITEMS( MYTICKET_UNIQUENUM INTEGER )
RETURNS ( TICKET_UNIQUENUM INTEGER
, TICKET_ENTRYNO INTEGER
, HOUSE_UNIQUENUM INTEGER
, PROD_NAME . VARCHAR(40)

A select * from GETTICKETITEMS(75827)

========================================================

Old IB_SQL on FB1.5.3 produces

Fieldnames:
TICKET_UNIQUENUM
TICKET_ENTRYNO
HOUSE_UNIQUENUM
PROD_NAME

Fields Field Type
TICKET_UNIQUENUM Integer
TICKET_ENTRYNO Integer
HOUSE_UNIQUENUM Integer
PROD_NAME VarText(40)

========================================================


New IB_SQL on FB2.0.0 produces
Fieldnames
GETTICKETITEMS.TICKET_UNIQUENUM
GETTICKETITEMS.TICKET_ENTRYNO
GETTICKETITEMS.HOUSE_UNIQUENUM
GETTICKETITEMS.PROD_NAME

Fields
Field Type
GETTICKETITEMS.TICKET_UNIQUENUM (Integer)INTEGER
GETTICKETITEMS.TICKET_ENTRYNO (Integer)INTEGER
GETTICKETITEMS.HOUSE_UNIQUENUM (Integer)INTEGER
GETTICKETITEMS.PROD_NAME (VarText)VARCHAR(40)

========================================================

New IB_SQL on FB1.5.3 produces
Fieldnames
TICKET_UNIQUENUM
TICKET_ENTRYNO
HOUSE_UNIQUENUM
PROD_NAME

Fields
Field Type
GETTICKETITEMS.TICKET_UNIQUENUM (Integer)INTEGER
GETTICKETITEMS.TICKET_ENTRYNO (Integer)INTEGER
GETTICKETITEMS.HOUSE_UNIQUENUM (Integer)INTEGER
GETTICKETITEMS.PROD_NAME (VarText)VARCHAR(40)