Subject | Re: [ib-support] Re: Problems with Firebird 1.0 and Dialect 3 |
---|---|
Author | Thomas Miller |
Post date | 2002-09-11T13:48:50Z |
Unfortunately I am a newbie when it comes to FB/IB procedural language.
I am primarily an Oracle guy. That said, you should be able to get help
from some of the experts here with these 4 triggers.
stevenggibb wrote:
Thomas Miller
Delphi Client/Server Certified Developer
BSS Accounting & Distribution Software
BSS Enterprise Accounting FrameWork
http://www.bss-software.com
I am primarily an Oracle guy. That said, you should be able to get help
from some of the experts here with these 4 triggers.
stevenggibb wrote:
>I tried the following:--
>
>1. isql -extract -output gms1.sql grantmgt.gdb
>2. added to statements to script
>
> SET SQL DIALECT 2;
> OUTPUT RESULTS.TXT;
> CREATE DATABASE 'D:\100\Grantmgt.gdb'
> USER 'SYSDBA' PASSWORD 'masterkey'
> PAGE_SIZE 4096;
>
>3. isql -i
>
>The ISQL output only suggested problems with four triggers. These
>triggers work in Dialect 1 and do not seem to be related to the
>errors I am seeing in stored procedure executions. Moreover, I do not
>understand the problem with these triggers. An example of the ISQL
>Dialect 2 problem with one of the four triggers is below:
>
>
>
Thomas Miller
Delphi Client/Server Certified Developer
BSS Accounting & Distribution Software
BSS Enterprise Accounting FrameWork
http://www.bss-software.com