Subject Re: [firebird-support] useing char_length in the trigger
Author Martijn Tonies

>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';
> if char_length(TeklifNoStr) = 8 then SifirTakfiye ='00';

IF (...expression...)

Everything for an IF should go inside parenthesis.

With regards,

Martijn Tonies
Upscene Productions

Download Database Workbench for Oracle, MS SQL Server, Sybase SQL
Anywhere, MySQL, InterBase, NexusDB and Firebird!