Subject | Re: [firebird-support] isql command line |
---|---|
Author | Milan Babuskov |
Post date | 2004-12-19T20:27:04Z |
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1
Todd Fisher wrote:
| I'm using isql in a makefile. Is it possible to pass the isql
| command a parameter that
| will get it to return an error code if the sql that it processes has
an error?
I think some new versions of isql can do it. The old ones (shipped
with previous versions of Firebird) can't.
| I see that if the input file is not correctly parsed a error is
returned 1.
|
| Why not assign an alternate return value for sql execution errors,
such as 2.
If you can afford to send statement by statement, you can try my
FBExport tool. It returns various error codes depending on type of
error that occurs:
http://fbexport.sourceforge.net
- --
Milan Babuskov
http://www.flamerobin.org
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.0.7 (GNU/Linux)
Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org
iQCVAwUBQcXkGLayZhcvK4sNAQIbxQP+MplNIazJymyqVYxozPa6iis4s+Rsm4Kv
swQ7MfoOz9vhxTMhaHOk2UAaCIJy6EmEtMl0nM4BhHRHFTEeQXjUr4tyhAkKaLAc
LYmdomwfj5WeIN53qlqRPdzBi3VkgxQckR+Jn3zaPy5o/N3WDHWZV/tMAVeJS9G6
NUQYoVjA9Fc=
=G0uq
-----END PGP SIGNATURE-----
Hash: SHA1
Todd Fisher wrote:
| I'm using isql in a makefile. Is it possible to pass the isql
| command a parameter that
| will get it to return an error code if the sql that it processes has
an error?
I think some new versions of isql can do it. The old ones (shipped
with previous versions of Firebird) can't.
| I see that if the input file is not correctly parsed a error is
returned 1.
|
| Why not assign an alternate return value for sql execution errors,
such as 2.
If you can afford to send statement by statement, you can try my
FBExport tool. It returns various error codes depending on type of
error that occurs:
http://fbexport.sourceforge.net
- --
Milan Babuskov
http://www.flamerobin.org
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.0.7 (GNU/Linux)
Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org
iQCVAwUBQcXkGLayZhcvK4sNAQIbxQP+MplNIazJymyqVYxozPa6iis4s+Rsm4Kv
swQ7MfoOz9vhxTMhaHOk2UAaCIJy6EmEtMl0nM4BhHRHFTEeQXjUr4tyhAkKaLAc
LYmdomwfj5WeIN53qlqRPdzBi3VkgxQckR+Jn3zaPy5o/N3WDHWZV/tMAVeJS9G6
NUQYoVjA9Fc=
=G0uq
-----END PGP SIGNATURE-----