Settings and activity

304 results found

  1. 1 vote
    1 comment  ·  SQL Complete  ·  Admin →
    How important is this to you?
    An error occurred while saving the comment
    AdminDevart (_, Devart) commented  · 

    Hi,

    Thanks for your patience!

    We would like to suggest utilizing the option "Do not load suggestions for the following databases."

    Best,

    Devart Support Team

  2. 1 vote
    1 comment  ·  SQL Complete  ·  Admin →
    How important is this to you?
    An error occurred while saving the comment
    AdminDevart (_, Devart) commented  · 

    Hi,

    Thanks for your patience!

    Please be informed that quick info is available for all database objects.

    Best,

    Devart Support Team

  3. 1 vote
    1 comment  ·  SQL Complete  ·  Admin →
    How important is this to you?
    An error occurred while saving the comment
    AdminDevart (_, Devart) commented  · 

    Hi,

    Thanks for your patience!

    Just want to inform you that it is already implemented.

    So we would like to suggest updating to the latest version and check there.

    Best,

    Devart Support Team

  4. 1 vote
    1 comment  ·  SQL Complete  ·  Admin →
    How important is this to you?
    An error occurred while saving the comment
    AdminDevart (_, Devart) commented  · 

    Hi,

    Thanks for your patience!

    Just want to inform you that it is already implemeted.

    Please use "Go to Error" by right-clicking.

    So we would like to suggest updating to the latest version and check there.

    Best,

    Devart Support Team

  5. 1 vote
    How important is this to you?
    An error occurred while saving the comment
    AdminDevart (_, Devart) commented  · 

    Hi,

    Thanks for your patience!

    We would like to suggest using the "Auto List Members" option in the settings and invoke the Completion List forcibly with the shortcut - by default, it's CTRL+Space.

    Best,

    Devart Support Team

    An error occurred while saving the comment
    AdminDevart (_, Devart) commented  · 

    When typing the column name in SELECT statements after entering the comma symbol the context-based prompt comes up (if after the FROM keyword the table name is provided). If you just want to enter the blank space you need to click the Space button. The context-based prompt just will keep coming up. If you press the Enter button the cursor moves to the new row and the context-based prompt disappears. If you just want the context-based prompt to be disappeared you have to click the Escape button. If you start entering first letter(s) of the column name the context-based prompt comes up with the relevant table names.
    Therefore, we don't count your request as the issue (bug). It's just by design.
    Note, using the Format Document feature you can customize formatting of queries.

  6. 1 vote
    1 comment  ·  SQL Complete » Bugs  ·  Admin →
    How important is this to you?

    Could you please clarify if it does not work only for offline databases or for each database on the server?

    A video or screenshots would be also of help.

    An error occurred while saving the comment
    AdminDevart (_, Devart) commented  · 

    Hi,

    Thanks for your patience!

    Please note that metadata is retrieved from the database.

    If there's no connection, database object suggestions won't be displayed.

    Best,

    Devart Support Team

  7. 1 vote
    1 comment  ·  SQL Complete » Bugs  ·  Admin →
    How important is this to you?
    An error occurred while saving the comment
    AdminDevart (_, Devart) commented  · 

    Hi,

    Thanks for your patience!

    Just want to inform you that it is already fixed.

    Columns from tables in the SELECT statement are now being read correctly, including those used in PATINDEX('%text%', col_name).

    So we would like to suggest updating to the latest version and check there.

    Best,

    Devart Support Team

  8. 1 vote
    How important is this to you?

    dbForge parses the object only after it’s declared. So, if the table is declared in the INTO clause, it will be offered only below the place it’s declared in the script and not above.

    An error occurred while saving the comment
    AdminDevart (_, Devart) commented  · 

    Hi,

    Thanks for your patience!

    Please note that if you're using CREATE TABLE #TempTable in the same document,

    your temp table will be included in the DROP TABLE IF EXISTS statement on the first line.

    Best,

    Devart Support Team

  9. 1 vote
    1 comment  ·  SQL Complete » Bugs  ·  Admin →
    How important is this to you?
    An error occurred while saving the comment
    AdminDevart (_, Devart) commented  · 

    Hi,

    Thanks for your patience!

    Just want to inform you that it is already fixed.

    So we would like to suggest updating to the latest version and check there.

    Best,

    Devart Support Team

  10. 1 vote
    How important is this to you?

    You could use the snippets functionality of dbForge SQL Complete.

    The snippet can be as follows:
    SELECT TOP $count$ *
    FROM $schema$.$table_name$

    An error occurred while saving the comment
    AdminDevart (_, Devart) commented  · 

    Hi,

    Thanks for your patience!

    Just want to inform you that it is already implemented in the interface.

    Adjust the displayed quantity in the options.

    So we would like to suggest updating to the latest version and check there.

    Best,

    Devart Support Team

  11. 1 vote
    1 comment  ·  SQL Complete  ·  Admin →
    How important is this to you?

    Could you please send us the screenshots of the actual and expected results to our support system at supportATdevartDOTcom for investigation?

    An error occurred while saving the comment
    AdminDevart (_, Devart) commented  · 

    Hi,

    Thanks for your patience!

    Please be informed that formatting subqueries can be configured in the settings.

    Best,

    Devart Support Team

  12. 2 votes
    How important is this to you?
    An error occurred while saving the comment
    AdminDevart (_, Devart) commented  · 

    Hi,

    Thanks for your patience!

    Just want to inform you that it is already implemented.

    You can sort by clicking on the table header in the result grid.

    So we would like to suggest updating to the latest version and check there.

    Best,

    Devart Support Team

  13. 2 votes
    How important is this to you?
    An error occurred while saving the comment
    AdminDevart (_, Devart) commented  · 

    Hi,

    Thanks for your patience!

    Please be informed that you can generate an insert template by right-clicking on the table name in the database tree and selecting "Generate Script As" option.

    Best,

    Devart Support Team

  14. 2 votes
    How important is this to you?
    An error occurred while saving the comment
    AdminDevart (_, Devart) commented  · 

    Hi,

    Thanks for your patience!

    Please be informed that there is a separate section for ORDER BY, GROUP BY clauses in both queries and subqueries in the formatting profile settings.

    Best,

    Devart Support Team

  15. 2 votes
    How important is this to you?
    An error occurred while saving the comment
    AdminDevart (_, Devart) commented  · 

    Hi,

    Thanks for your patience!

    Please be informed that you can insert all columns when pressing Tab.

    Best,

    Devart Support Team

  16. 2 votes
    1 comment  ·  SQL Complete  ·  Admin →
    How important is this to you?
    An error occurred while saving the comment
    AdminDevart (_, Devart) commented  · 

    Hi,

    Thanks for your patience!

    Please note that you can share your snippets.

    And also you can find the path to the snippet files in the snippet manager under the "Location" field.

    Best,

    Devart Support Team

  17. 2 votes
    1 comment  ·  SQL Complete  ·  Admin →
    How important is this to you?
    An error occurred while saving the comment
    AdminDevart (_, Devart) commented  · 

    Hi,

    Thanks for your patience!

    We would like to suggest using the option "Do not load suggestions for the following databases."

    There's currently no option for ranking.

    Best,

    Devart Support Team

  18. 3 votes
    How important is this to you?
    An error occurred while saving the comment
    AdminDevart (_, Devart) commented  · 

    Hi,

    Thanks for your patience!

    Right now suggestions are adjusted based on previous joins.

    It's quite challenging to predict which tables you want to join, and new logic for constructing joins in the suggestions is required.

    Please be infromed that we have passed this feature request to our Product team for a review.

    A hight number of votes here would speed up the review and implementation process, so let's hope to get more votes.

    Once there is an update regarding implementation and release, you will be informed.

    Best,

    Devart Support Team

  19. 3 votes
    How important is this to you?
    An error occurred while saving the comment
    AdminDevart (_, Devart) commented  · 

    Hi,

    Thanks for your patience!

    Please note that fields from the main select are suggested in the subquery, so we would like to suggest using them.

    Best,

    Devart Support Team

  20. 3 votes
    1 comment  ·  SQL Complete  ·  Admin →
    How important is this to you?
    An error occurred while saving the comment
    AdminDevart (_, Devart) commented  · 

    Hi,

    Thanks for your patience!

    We would like to suggest to look for Window.NextTab/Window.PreviousTab in the shortcuts.

    Just set up convenient shortcuts and use them.
    Best,

    Devart Support Team