Subject | Re: RES: [firebird-support] soundex |
---|---|
Author | Helen Borrie |
Post date | 2005-11-15T04:25:10Z |
At 01:12 AM 15/11/2005 -0200, you wrote:
traditional kind get unhappy if passed a null as input. For a safe update
statement, you should do this:
UPDATE indcemit set classificado = F_GENERATESNXINDEX(falecido)
where falecido is not null
Helen
>I am using the UDF in FreeUDFLib .ERm, could it be that falecido is nullable on that table? UDFs of the
>
>I have met one problem. I used basically the statement below.
>
>UPDATE indcemit set classificado = F_GENERATESNXINDEX(falecido)
>
>It works well with all tables but one. On this special table the script
>hangs and no result is reached. I have to reset my computer.
traditional kind get unhappy if passed a null as input. For a safe update
statement, you should do this:
UPDATE indcemit set classificado = F_GENERATESNXINDEX(falecido)
where falecido is not null
Helen