> I think this is it - two parameters with the same name.
>
> Perhaps you should rename the input parameter to:
> IN_R_SHARED
>
> As for myself, I usually name input parameter IN_<something>
> and output parameters OUT_<something>...
>
> How else should Firebird know what parameter it should use if
> you write R_CREATED_BY?
>
> With regards,
>
> Martijn Tonies
> Database Workbench - developer tool for InterBase, Firebird,
> MySQL & MS SQL Server.
> Upscene Productions
> http://www.upscene.com

I notice the same problem, unfortunately the mail server here is very slow
passing mail, thus I got your message after my last post :-( However, thank
you

danieL

____________________________
Comvision Pty. Ltd.

www.comvision.net.au