Subject [IBO] possible problem IBO4.7.Beta 5 and IB_SQL
Author Hans
Post date 2006-11-25T05:09:28Z
> [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)