Subject Re: [ib-support] Feature Request for FB 2.0
Author Martijn Tonies

> > You can post it to the Firebird devel list or you can send it to me
> > privately (I'll add it to the list during my next bug tracker update for
> > FB).
> I can find no firebird-devel list at yahoo.
> The request is really easy, it would very usefull, when stored procedures
> would support Domains.
> It's really a pain, when I change the domain of a field, I have to go
> all SP's, that use that field and have to change the data-type.

Domains aren't just about data types - they're Domains: that is, a
datatype with/out a check constraint and not null constraint and even a
default value.

In a stored procedure, what would a parameter or variable be when it is
defined as NOT NULL?!

I'd rather have the same construct as Oracle:

Declare a variable as: myvar %EMPLOYEE.EMPNO%

(or something, cannot exactly remember)

Martijn Tonies
InterBase Workbench - the developer tool for InterBase and Firebird

Upscene Productions

"This is an object-oriented system.
If we change anything, the users object."