Subject Domains and parameters
Author Louis van Alphen
I may be a bit behind times, but when I used IB4.2, you couldn't use
domains as parameter types for SPs. Therefore when writing a SP, you had to
use the actual defnition for the domain as the type for the SP parameter.

E.g. CREATE DOMAIN Password AS VARCHAR(12) forgive me if the sytax
is not 100% correct

CREAT PROCEDURE SomeSP(Passwd VARCHAR(12))
AS
BEGIN
SUSPEND;
END

And if your domain changed, you were stuffed.

What is the current situation?

If still the same, is there any way this may be brought in. Like any other
language where you have typedef type declarations. This would change the
above example to:

CREATE DOMAIN Password AS VARCHAR(12)

CREAT PROCEDURE SomeSP(Passwd Password)
AS
BEGIN
SUSPEND;
END

Please let me know if this is already the case.


Thank you
L.J. van Alphen
lja@...