Download the documentation from the ibphoenix web site. It contains many
examples and full descriptions of the SQL syntax.


Even better, buy yourself the Firebird book.

Regards

Tim

At 13:59 25/01/2005, you wrote:

>Hi,
>
>How can I get the list of all Firebird functions and their usage? I tried
>this trigger and was surprised that it could not go.
>
>SET TERM ^ ;
>CREATE TRIGGER ALLOWANCE_TYPE ACTIVE
>BEFORE INSERT POSITION 0
>AS
>BEGIN
> IF (SUBSTRING(NEW.NAMA,1,8) ='OTHERINC') THEN
> NEW.TYPI='S';
> ELSE
> NEW.TYPI='N';
>END^
>SET TERM ; ^
>
>At first I used SUBSTR function as contained in the InterBase Doc and got
>an error message that SUBSTR is not a Firebird function and then used the
>SUBSTRING and could not get through either.
>
>Can someone please tell me what is wrong with the trigger above and
>possibly give me a Firebird function rundown.
>
>Best regards.
>
>Tope Akinniyi.
>
>
>---------------------------------
>ALL-NEW Yahoo! Messenger - all new features - even more fun!
>
>[Non-text portions of this message have been removed]
>
>
>
>
>
>
>----------
>Yahoo! Groups Links
> * To visit your group on the web, go to:
> *
> <http://groups.yahoo.com/group/firebird-support/>http://groups.yahoo.com/group/firebird-support/
>
> *
> * To unsubscribe from this group, send an email to:
> *
> <mailto:firebird-support-unsubscribe@yahoogroups.com?subject=Unsubscribe>firebird-support-unsubscribe@yahoogroups.com
>
> *
> * Your use of Yahoo! Groups is subject to the
> <http://docs.yahoo.com/info/terms/>Yahoo! Terms of Service.

[Non-text portions of this message have been removed]