At 11:27 AM 04-08-00 +0200, you wrote:

Louis,
It hasn't changed. You still have to use supported data types in SPs and
triggers.

Helen

>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@...
>
>
>
>
>To unsubscribe from this group, send an email to:
>IB-Architect-unsubscribe@onelist.com
>

http://www.interbase2000.org
___________________________________________________
"Ask not what your free, open-source database can do for you,
but what you can do for your free, open-source database."
(J.F.K.)