Subject Re: [firebird-support] useing char_length in the trigger
Author Paul Vinkenoog
ahmetdenize wrote:

> I have trigger for generade order number. I want to use char_length(TeklifNoStr) in the if command . but it is not working.
> there is error massage is
> "Token unknown - line 30, column 9
> char_length"

> if char_length(TeklifNoStr) = 9 then SifirTakfiye ='0';

You forgot the parentheses around the condition:

if (char_length(TeklifNoStr) = 9) then SifirTakfiye ='0';

Paul Vinkenoog