Re: help with TCL function

Op 10 Sep 2003 (15:27), schreef Jules Alberts <jules(dot)alberts(at)arbodienst-limburg(dot)nl>:
> Hello everybody,
>
> Someone helped me earlier with this TCL trigger function:
>
> create or replace function tlow() returns trigger as '
> set NEW($1) [string tolower $NEW($1)]
> return [array get NEW]'
> language 'pltcl';
>
> I use it to force lowercase of values inserted in the db. There is one
> problem though, if the parameter is absent, the function will give an
> error message. I would like it to rather check for null before tolower
> is applicated. In semicode:
>
> if ($1 <> NULL) {
> set NEW($1) [string tolower $NEW($1)]
> }
> return [array get NEW]'
>
> but I have no idea how to do this in TCL. Can somebody please tell me?
> Thanks a lot!

I found argisnull, but I can't run it, apparently it cannot be used in
triggers :-( Does anybody know a solutions for this problem? Thanks!