There was a thread a while ago about how useful it would be to have "snippets" functionality in the EDBMgr SQL Statement and SQL Script windows.

i.e. We all have to write things like:

PREPARE Stmt FROM
'' SELECT Name FROM Configuration.Files '';
OPEN Crsr;

Quite often, it would be nice to have a way of dropping these types of statements into scripts quickly.

At the time people talked about something like auto-completion functionality (like in Delphi). I can see this would be great, but also perhaps hard to code.

An easier solution might be to extend EDBMgrs existing "drag and drop" functionality.

i.e. I can already "drag" a pre-written function, procedure (or even table!) from the treeview into a script window & see it converted into SQL.

What if there was a node on the tree for "Snippets", it could be pre-loaded with some basic, useful ones, but have an extra node for the user to add their own.

Right click, "Create Snippet", would open a simple SQL-Memo Window, with a "Save" button and a "Title" Edit.

Dragging these snippets into the SQL Editor would dump whatever SQL had been written there into the script.

Adam,

> i.e. We all have to write things like:
>
> PREPARE Stmt FROM
> '' SELECT Name FROM Configuration.Files '';
> OPEN Crsr;

I use AutoHotKey for that. It's very easy to write and works great.

E.g. (just type st (for statement)):

::<st::DECLARE Result CURSOR WITH RETURN FOR Stmt;{ENTER}PREPARE Stmt
FROM{ENTER}'SELECT * from';{ENTER}OPEN Result using Parameter;{ENTER}

Regards Uli

>>I use AutoHotKey for that. It's very easy to write and works great.

... Thanks for the suggestion, I have downloaded it & will check it out. It looks really useful!

I still think it would be nice to have the feature built into EDBMgr, especially if a few frequently used pieces of code were pre-loaded.

Adam

I've had AutoHotKey for ages - its main use is to start my alternative to Windows Explorer via the win-E key. Never thought of using it that way though. Damn good idea.


Roy Lambert

Uli


You must have a different version of AutoHotKey to me. I'm on 1.0.48.03 but reading the on-line help I came up with

::>st::
(
PREPARE Stmt FROM
SELECT * from
OPEN Result using Parameter;    
)

neato

Roy Lambert

Roy,

> You must have a different version of AutoHotKey to me. I'm on 1.0.48.03 but reading the on-line help I came up with
>
> ::>st::
> (
> PREPARE Stmt FROM
> SELECT * from
> OPEN Result using Parameter;
> )

Maybe. Does the code which I posted, not work with your version?

Anyway you can use AHK even to insert tablenames e.g. by displaying
message boxes and thus reduce typing to a minimum.

Uli

Uli

>Maybe. Does the code which I posted, not work with your version?

Nope, not sure which bits giving the problem but I like the layout I used

>Anyway you can use AHK even to insert tablenames e.g. by displaying
>message boxes and thus reduce typing to a minimum.

Mmmm, you'll have to post an example of that.

Roy

Roy,

> Nope, not sure which bits giving the problem but I like the layout I used

You are right - I'll have to update.

> Mmmm, you'll have to post an example of that.

Just a small and simple sample:

::test::
    InputBox, providedString, Tablename, Tablename:
    if NOT ErrorLevel
    {
        Send SELECT * from %providedString%{Enter}
    }
Return

Uli

Addition:

I wrote an application that stores all snippets and other templates (not
only for EDBManager) in a database (EDB of course) and creates the AHK
script(s) when anything has been changed. See the attached screenshot.

Regards Uli

Uli


Very nice. Now be a good boy and share your toy with your friends

Pretty please

Roy Lambert