Subject | Re: [firebird-support] Script Won't Work |
---|---|
Author | Helen Borrie |
Post date | 2006-04-22T01:06:43Z |
At 04:03 AM 22/04/2006, you wrote:
"extraneous" ISQL commands that are not database access
statements don't get sent to the file.
When it encounters OUTPUT, SHOW <something>, EXIT, QUIT, and some
(though not all) SET <something> commands, which are all commands
specific to ISQL's own workings, it knows not to output them to the
file (which works properly about 99% of the time). Then, when
executing the file as an input file, if it comes across any
statements containing its own internal commands, it just no_ops them.
That's what is happening here. It's all fine for the script to
create and open the output file, but the script terminates without
having anything that ISQL encounters that has to be written to the file.
On the other hand, if you invoke isql with a combination of switches
that DOES have something ISQL can write out, your file won't be empty!
c:\Program Files\Firebird\Firebird_1_5\bin>isql -ex -t
"%%" "c:\program files\firebird\firebird_1_5\examples\employee.fdb"
-o c:\efgh.txt
./heLen
>Hi All:When writing to an output file, ISQL filters the output so that
>The Following script is being loaded, will run, create the output file but
>the output file is empty.
>Any Suggestions?
>/* Start Script */
>OUTPUT C:\RtFbISQLLog.rtf ;
>HELP ;
>OUTPUT ;
>QUIT ;
>/* End of Script */
"extraneous" ISQL commands that are not database access
statements don't get sent to the file.
When it encounters OUTPUT, SHOW <something>, EXIT, QUIT, and some
(though not all) SET <something> commands, which are all commands
specific to ISQL's own workings, it knows not to output them to the
file (which works properly about 99% of the time). Then, when
executing the file as an input file, if it comes across any
statements containing its own internal commands, it just no_ops them.
That's what is happening here. It's all fine for the script to
create and open the output file, but the script terminates without
having anything that ISQL encounters that has to be written to the file.
On the other hand, if you invoke isql with a combination of switches
that DOES have something ISQL can write out, your file won't be empty!
c:\Program Files\Firebird\Firebird_1_5\bin>isql -ex -t
"%%" "c:\program files\firebird\firebird_1_5\examples\employee.fdb"
-o c:\efgh.txt
./heLen