Where I work we are using Interbase 7 with Delphi for a commercial
product. The database has stored proc, triggers, fairly sophisticated. I
use several scripts which I run in from the commmand line and use isql
to build the database and fill some tables with data.

Out of curiosity I installed FirebirdSS-1.0.2.908-1 on my Redhat 7.3
system. The server works. With a little modification I got the scripts
that create the tables and stored procedures to work, but the script for
alter the procs fails. I used ibaccess to execute pieces of the failed
script and get errors about unknown tokens around the : character. I can
get past them if I delete the : but then I get 'Dynamic SQL Error
expression evaluation not supported.'

Any ideas on what's wrong?

--
Doug Pomerenke <djp@...>