SqlDbx Forum

aangelo

Member

Bug - Edit Function/Procedure

SqlDbx Version 3.62 (Professional Edition)
OS: Windows 7 Professional SP1
Database Informix

Hello!

In Options I set Script DROP for tables, views (a quite useful option).

When I edit a Function (from popup menu) having the following header

create function myFunction
(   p_anno          smallint
,   p_mese          smallint
,   p_fl_output     smallint default 0
) 

before the source SqlDbx adds the statement

drop function myFunction (smallint, smallint, smallint default 0);

but this generates an error because Informix accepts only

drop function myFunction  (smallint, smallint, smallint);

A similar problem arises when a parameter type references a field type:
drop function informix.popola_produttivita_macchine (smallint, smallint, char);

create function myFunction2
(   p_anno          smallint    
,   p_mese          smallint    
,   cd_cn_lavoro    like    myTable.myField
)

Thank you!

Last edited by aangelo (2013-09-05 03:15:00)