Announcement

Collapse
No announcement yet.

Snippet Code Inclusion

Collapse
X
  • Filter
  • Time
  • Show
Clear All
new posts

  • Snippet Code Inclusion

    Is it possible to get Snippets in Navicat? Not Favorites, but actual Snippets.

    I use both VS2015 and when needed, the MySQL Workbench and I find having Snippets extremely time efficient and just plain handy. I would recommend it doesn't have to be as extensive as VS's version with replacements and surrounds, but the ability to drop resusable code into a sproc or function would streamline workflow.

    Example:

    Almost every single function I create includes the following code (cleaned up but basically the code snippet used):

    Code:
    DECLARE success TINYINT DEFAULT 0;
    DECLARE logRes INT DEFAULT 0;
    
    SELECT logentry_add(xx, xx, NULL, IF(success = 1, 0, 1), 0) INTO logRes;
    
    RETURN success;
    Currently to include this using Navicat MySQL I have to either:
    1. Enter the code manually.
    2. Open another function that already has the code in it, copy it, paste it and then clean it up.
    3. Open The Guide (what I currently use to save snippets for use in programs that do not support it), copy the base code into the function.

    Hope this makes sense. Thanks for your consideration.

    Jim H.

  • #2
    Thanks for your suggestion. Your request is already in our development list. We will keep improving Navicat in future.

    Comment

    Working...
    X