On 15/10/2015 13:57, p519446 wrote: > IMO, need to specify SET TERM before every block causes only > irritation and nothing more. > > More than 50% of all errors in the scripts that I prepare by typing > relate to missing of this statement or specifying "^" and ";" in wrong > order. Damn it! > > IBExpert as most well-known IDE (and maybe starting point for almost > anyone who begin to work with FB) does not require to specify them at > all - so, it will be always borrow not to forget about these 'set > term' for anyone who decide to 'switch' his scripts from IBE into ISQL. > Also, when we need to 'split' huge script with thousands of procedures > into several parts, one need to add 'set term' at the start and end of > each file. > > It seems you like to complicate things.
Call "isql -term !" and do not use SET TERM at all, just terminate your full commands with "!". If you want isql to be smart, it would need heuristics for different commands (see my ALTER DATABASE BEGIN BACKUP example), or it will need a complete parser. Both solutions has the drawback to tie a ISQL version to a engine version, so, a bad design to fix a non-existent problem. Everybody capable of write SQL commands and understanding Firebird knows the full command does not need a semicolon in the end. But, somebody wrote ISQL to require it (as the default TERM), being it the same character that separate commands in DDL blocks (that is what's needed by Firebird). Microsoft tool wants a GO isolated in each line, or something similar, and is much worse to use. Oracle uses something that I didn't understand exactly, wanting a '/' after some commands. That has no (clear) logic. I just use it, sometimes it doesn't appear to be required but it is. You just don't known exactly what to do, different than Firebird, with uses a simple and effective approach. So what good design you (all people wanting this) propose? Adriano ------------------------------------------------------------------------------ Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel
