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