Subject | Re: Wrong output script generate by isql. |
---|---|
Author | hamacker |
Post date | 2013-07-02T19:00:42Z |
Sorry, I copy and paste wrong cmd.
Correct is :
isql.exe" 'C:\SESMT\DADOS\SESMT.FDB' -U "SYSDBA" -P "masterkey" -x -now -o
"c:\temp\sesmt.sql"
2013/7/2 hamacker <sirhamacker@...>
Correct is :
isql.exe" 'C:\SESMT\DADOS\SESMT.FDB' -U "SYSDBA" -P "masterkey" -x -now -o
"c:\temp\sesmt.sql"
2013/7/2 hamacker <sirhamacker@...>
> Hi All,[Non-text portions of this message have been removed]
>
> When I execute :
> isql.exe "localhost:F:\SESMT\dados\SESMT.fdb" -U "SYSDBA" -P "masterkey"
> -now -i "c:\temp\sesmt.sql" -o "c:\temp\firebird-isql.log"
>
> I extract db metadata, but in this script appear some errors like :
>
> (...)
> OPCIONAL CHAR(1) CHARACTER SETISO8859_1 ,
> STATUS CHAR(1) CHARACTER SETISO8859_1 )
> (...)
>
> Any char/varchar declaration inside procedures will be transformed to
> include "CHARACTER SETISO8859_1", I think that was missed space between SET
> and ISO8859_1. If I changed to domain, like :
>
> create domain d_opcional char(1)
>
> and use d_opcional instead char(1) then no error appears, script is
> generate correctly.
>
> I would like to know if a bug of isql.exe or I missed something in source
> database.
>
> I tested in fb2.5.2.
>