SqlDbx
You are not logged in.
Pages: 1
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)
Offline
Pages: 1