>Hi people,
>

Let's say I have domains defined as:

>CREATE DOMAIN VC16 AS VARCHAR(16)
>CREATE DOMAIN MYDATE AS DATE

>Is there a way that I can do something like this?

>CREATE PROCEDURE SP_TMP (
>pFIRST_DATE MYDATE,
>pLAST_DATE MYDATE
>)
>AS
> DECLARE VARIABLE NAME VC16;
> DECLARE VARIABLE LASTNAME VC16;
> BEGIN
> ..

No, you can not. Firebird doesn't allow you to use domain at stored
procedure/trigger. We hope FB-team will do that someday :-)

>When I try do create a stored procedure like this, Firebird says it
>doesn't know anything about MYDATE and VC16. And when I create a
>stored procedure by typing the full field definitions, it creates new
>domains as RDB$4269, RDB$4270, RDB$4271 and so on.. As you see I have
>already many domains so wouldn't it be nice if I could reduce some?
>(I have 162 tables, 151 procedures, 90 users, 3.5gb firebird file)

Firebird automatically save your new datatype to new domain and save that as
metadata. It's like system table that make firbird easier to identify your
column attribute.



Regards

Agung w http://www.firebird-indonesia.net
<http://www.firebird-indonesia.net/>



[Non-text portions of this message have been removed]