| Subject | Re: [firebird-support] useing char_length in the trigger |
|---|---|
| Author | Paul Vinkenoog |
| Post date | 2010-12-29T14:08:55Z |
ahmetdenize wrote:
if (char_length(TeklifNoStr) = 9) then SifirTakfiye ='0';
Paul Vinkenoog
> I have trigger for generade order number. I want to use char_length(TeklifNoStr) in the if command . but it is not working.You forgot the parentheses around the condition:
> there is error massage is
> "Token unknown - line 30, column 9
> char_length"
> if char_length(TeklifNoStr) = 9 then SifirTakfiye ='0';
if (char_length(TeklifNoStr) = 9) then SifirTakfiye ='0';
Paul Vinkenoog