Hi,

> > 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

through

> 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
particular
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
http://www.interbaseworkbench.com

Upscene Productions
http://www.upscene.com

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