|
From: Gerd W. <ger...@t-...> - 2020-05-21 00:21:00
|
Am 19.05.20 um 16:59 schrieb dev...@ro...: > > Hi, > > working with databases requires quite often to use one of the > following sql "patterns": > > SELECT * FROM WHERE INSERT INTO () VALUES() UPDATE SET WHERE > DELETE FROM WHERE > > Is it possible to implement a small piece of code so that each of > these "prototypes" will be created in the sql command window, e.g. > CRTL + ALT + S for the SELECT statement? Have a look at SQuirreL's bookmarks. See menu Session --> Bookmarks --> Add Bookmark / Edit Boolmarks. These menus item are also available as toolbar buttons. Use the ctrl+J shortcut to copy a bookmark to the SQL editor. Please also see the "SQL Bookmark Plugin" section of SQuirreL's help. > > > The script plugin doesn't seem to support delete, update and select > *. > > Please, is it possible to add these operations, too? Several of functions like these can be found in the "Scripts" section of the right mouse menu in the Object tree when a table is selected. > > The code completion does not work with substrings, i.e. given a table > name "TEST" will be displayed only when typing TE.. > > If SOME substring of TEST is uses, e.g. start typing ST the table > name is not found (or any other object). > > Is it possible to add this feature? Oftenly users cannot exactly > remember the name of a table exactly so this w'd be quite useful > (highlighting the typed string additionally at best). > > I noticed command completion in a WHERE clause sorts columns to the > top which is great, but in general some kind of highlighting of > spicific types with a dedicated colour, e.g. for columns, or > generally using a symbol for the object type w'd make it even > better. > > Showing a VIEW with (VIEW) is very useful already but maybe this can > still be extended further. These are good feature requests. Would you mind posting them here: https://sourceforge.net/p/squirrel-sql/feature-requests/ Thanks Gerd > > Many thanks > > Robert > > > > > > > _______________________________________________ Squirrel-sql-users > mailing list Squ...@li... > https://lists.sourceforge.net/lists/listinfo/squirrel-sql-users |
