Subject | Re: [Firebird-Java] Fixed one sql problem, found another |
---|---|
Author | Roman Rokytskyy |
Post date | 2005-09-12T17:32:49Z |
> My DDL runs fine with isql, but I am getting an error with the sqlNothing will help you except a custom Ant task - the <sql/> task is too
> command in ant.
"stupid" to respect the switch of the statement terminator in the SQL
script. And you must use ";" in the trigger and procedure body. In isql you
have something like SET TERM !!; and after the trigger body you have !! and
finally SET TERM ;!!.
You can find the simple script executor on our Wiki - it respects the SET
TERM command in the script. You can use that for your custom task. It would
be also great if you could contribute this task back to the project to help
others.
Roman