At 12:25 PM 23-04-02 +1200, Sandeep wrote:

>Where can I get the list of all functions in firebird?

In the release notes. You should read them, as select first has some
undesirable (nay, catastrophic) effects if you use it thoughtlessly with
DELETE...

>Why doesn't
> select substring (fieldA from 0 for 2) from tableA
>work? I get exception [Positive value expected]

Because the dataset doesn't have a "row 0". It will either have no rows or
it will have one or more. Positive means "non-zero and non-negative".

fieldA from 1 for 2 will capture the first two rows.

Helen

All for Open and Open for All
Firebird Open SQL Database · http://firebirdsql.org ·
http://users.tpg.com.au/helebor/
_______________________________________________________