Skip to content

Settings and activity

300 results found

  1. 1 vote
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    1 comment  ·  SQL Complete  ·  Admin →
    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    An error occurred while saving the comment
    AdminDevart (_, Devart) commented  · 

    Hi,

    Thanks for your patience!

    We would like to recommend using separators between SELECT statements, as they are context-dependent.

    Best,

    Devart Support Team

  2. 1 vote
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    1 comment  ·  SQL Complete  ·  Admin →
    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    An error occurred while saving the comment
    AdminDevart (_, Devart) commented  · 

    Hi,

    Thanks for your patience!

    Actually, you can create the desired template for the alias in the settings.

    Best,

    Devart Support Team

  3. 1 vote
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    1 comment  ·  SQL Complete  ·  Admin →
    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    An error occurred while saving the comment
    AdminDevart (_, Devart) commented  · 

    Hi,

    Thanks for your patience!

    We would like to suggest using the Wrap condition option after WHERE.

    Best,

    Devart Support Team

    AdminDevart (_, Devart) shared this idea  · 
  4. 1 vote
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    1 comment  ·  SQL Complete  ·  Admin →
    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    An error occurred while saving the comment
    AdminDevart (_, Devart) commented  · 

    Hi,

    Thanks for your patience!

    We would like to suggest using the settings in the formatting profile for the JOIN operator.

    Best,

    Devart Support Team

    AdminDevart (_, Devart) shared this idea  · 
  5. 1 vote
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    1 comment  ·  SQL Complete  ·  Admin →
    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    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- use the Alt+Shift+arrow keys, then enter the text.

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

    Best,

    Devart Support Team

  6. 1 vote
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    An error occurred while saving the comment
    AdminDevart (_, Devart) commented  · 

    Hi,

    Thanks for your patience!

    The selects are the same - we can't see the issues.

    Best,

    Devart Support Team

  7. 1 vote
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    1 comment  ·  SQL Complete  ·  Admin →
    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    An error occurred while saving the comment
    AdminDevart (_, Devart) commented  · 

    Hi,

    Thanks for your patience!

    We would like to suggest using formatting functionality.

    Best,

    Devart Support Team

  8. 1 vote
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    1 comment  ·  SQL Complete  ·  Admin →
    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    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

  9. 1 vote
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    1 comment  ·  SQL Complete  ·  Admin →
    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    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

  10. 1 vote
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    1 comment  ·  SQL Complete  ·  Admin →
    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    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

  11. 1 vote
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    1 comment  ·  SQL Complete  ·  Admin →
    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    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

  12. 1 vote
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    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.

  13. 1 vote
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    1 comment  ·  SQL Complete » Bugs  ·  Admin →
    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    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

  14. 1 vote
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    1 comment  ·  SQL Complete » Bugs  ·  Admin →
    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    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

  15. 1 vote
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    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

  16. 1 vote
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    1 comment  ·  SQL Complete » Bugs  ·  Admin →
    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    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

  17. 1 vote
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    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

  18. 1 vote
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    1 comment  ·  SQL Complete  ·  Admin →
    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    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

  19. 2 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    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

  20. 2 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    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