Problems with ZSQLProcessor

[silviojgfr]

Hi, folks

I need to make an application to update the database structure on my costumers computers. I use ZEOS 6.5.1 alpha CVS an Firebird 1.5.

I use DBComparer to generate the DDL file with the updates I have to do. I've tested this DDL on IBExpert's Script Executive, and it works.

My application has a ZConnection and a ZSQLProcessor. ZSQLProcessor has no changes, properties are with default settings, except for the Connection and Script properties that I had to set them.

When I run the program, an error is raised with this msg:

Code: Select all

SQL Error:  Dynamic SQL Error SQL error code = -104 Token unknown - line 3, char 5 TERM. Error Code: -104. Invalid token The SQL: 

SET TERM ^ 
; 

This script has codes to create triggers, tables, drops, alters.... Since it has run with IBExpert, I think the problem is with ZProcessor's property Delimiter (set to ";") and DelimiterType (set to "dtDefault").

I coudn't find any Zeos documentation in the site, so I don't know how to use these properties.

How can I make ZSQLProcessor works fine with my script (and all its creates, alters, drops and SET TERMs..)???

Early thanks...

Silvio Ribeiro
Joao Pessoa - Paraiba - Brasil

[mosca_morta]

Hello, Silvio! Its great, Im living on Joao Pessoa too, and Im a zeos debugger and developer of HeidiSQL Project Team.

Send me a email: fco_ernesto@yahoo.com.br

See you later.

[seekbirdy]

Ok then, maybe you guys could manage to ovetcome this error... But I have a same story with FB 2.0 and Zeos 6.6.5 "stable". Is that any workaround for this problem?