Problems with ZSQLProcessor
Posted: 11.11.2006, 06:11
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:
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
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 ^
; 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