Sharing macros on a network drive

[Apple_Sauce90]

Hello,

I'm relatively new PL/SQL developer and stumbled upon macros as convenient solution to record code snippets. Is it possible to share macros on a networked drive, thus increasing collaboration across differing team members.

I am coming away with mixed results at the moment. Where my team member certainly see's the .lib file when navigating to the shared folder, but her application doesn't seem to 'pick up' the macros I've stored there.

Currently using the archaic version 8.0.4.1514

Thoughts would be appreciated.

- Apples

 

[Marco Kalter]

It is not easily possible to share specific macros. It is possible to share your complete macro library, but for code snippets you may first want to check out the "AutoReplace" feature (Tools > Preferences > Editor / AutoReplace):

AutoReplace
When enabled, you can define words that are automatically replaced with a replacement text. For example, if you define the word wo with the replacement text

Pressing the Edit button allows you to edit the file with words and replacement texts. On each line in this file you can enter a word=replacement text specification. For example:

wo=when others then
rs=rollback to savepoint

You can also reference a template as replacement text. For example:

wh=Loops\While loop.tpl

In this case the While loop template from the Loops template subdirectory will be invoked, allowing you to use variables and cursor placement for the replacement text.

The Definition file field allows you to specify which file is used for the AutoReplace definitions.

The definition file mentioned above can easily be shared with colleagues.

 

[patch]

Or, you can take a look at my 'Templates' plugin. It provides the possibility to save you template in one of 3 groups (personal, group and company). The files for these different groups can be on different locations, for example a network share or a google drive.
bar-solutions.com/plugins.php

 

[Apple_Sauce90]

Interesting! thank you both. Macros, as much as I love them act a bit wonky.

In a perfect world, Redgate's SQL Prompt would be integrated with this tool but alas Templates mixed with auto correct will do.

thanks again!