Subject Re: [ib-support] Converting Interbase to Firebird
Author Helen Borrie
At 09:34 PM 4/05/2003 -0500, you wrote:
>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?

It's impossible to analyse without the exact text of the DDL that is
failing. Post the DDL.

heLen