Subject | SQL Scripts |
---|---|
Author | Ian Newby |
Post date | 2001-12-07T10:07:18Z |
Hi All,
Just a thought for Firebird 2. Is there any reason why Firebird cannot
accept multiple SQL Statements at the same time? Ie in a Delphi query
object send 50 SQL inserts to the database at once.
It seems to me that a lot of bugs are occuring due to the different
way different tools deal with SQL scripts; ISQL, IBConsole, Marathon,
Quickdesk etc all have script running facilities but these are all coded
at the interface level. It would be much simpler to maintain if the
script processing was performed by the server.
I appreciate that this can raise a number of problems, particularly if
multiple selects are performed, but I believe that it would reduce the
support burden if all the tools used an in built script runner... Single
point of failure.
Regards
Ian Newby
Just a thought for Firebird 2. Is there any reason why Firebird cannot
accept multiple SQL Statements at the same time? Ie in a Delphi query
object send 50 SQL inserts to the database at once.
It seems to me that a lot of bugs are occuring due to the different
way different tools deal with SQL scripts; ISQL, IBConsole, Marathon,
Quickdesk etc all have script running facilities but these are all coded
at the interface level. It would be much simpler to maintain if the
script processing was performed by the server.
I appreciate that this can raise a number of problems, particularly if
multiple selects are performed, but I believe that it would reduce the
support burden if all the tools used an in built script runner... Single
point of failure.
Regards
Ian Newby