Settings and activity
10 results found
-
57 votes
par20pinspot
supported this idea
·
-
2 votes
AdminPMs
(Admin, Devart)
responded
Could you please specify what product version you are using and perform the following:
1. Turn on tracing by selecting ‘SQL Complete → Trace → Start Tracing’ from the main menu.
2. Reproduce the issue and send us the *.log file with the latest date from the folder:
SystemDrive\Users\%UserName%\AppData\Roaming\Devart\dbForge SQL Complete\A video or screenshots would be also of help.
par20pinspot
shared this idea
·
-
1 vote
AdminDevart
(_, Devart)
responded
Could you please describe it in more detail and provide us the scripts?
Screenshots would be also of help.
An error occurred while saving the comment par20pinspot
shared this idea
·
-
9 votespar20pinspot
supported this idea
·
-
1 votepar20pinspot
shared this idea
·
-
25 votes
An error occurred while saving the comment par20pinspot
commented
This has been completed. Go to Tools -> Options -> Keyboard -> Search for "ExecuteCurrentStatement"
-
3 votespar20pinspot
shared this idea
·
-
2 votes
-
2 votespar20pinspot
shared this idea
·
-
12 votes
An error occurred while saving the comment par20pinspot
commented
Intellisense for tables doesn't work for CamelCase'd table names with an underscore in the name. E.g. If you have 2 tables - PrimaryUsers & PrimaryUsers_OLD, typing P+U brings up PrimaryUsers but not PrimaryUsers_OLD. Typing P+O brings up PrimaryUsers_OLD
In the below query, when you type "SELECT * FROM NewU" and hit tab or whatever key to utilize the code completion on NewUsers, "NewUsers" is not automatically aliased like it would be if NewUsers was an actual table. It should become "SELECT * FROM NewUsers AS nu" according to my settings for table aliasing. The column name prefix issue on "*" expansion appears to be resolved though.
WITH NewUsers AS (
SELECT
t1.UserID
, t1.UserName
FROM (
VALUES
(1, 'admin')
, (2, 'developer')
, (3, 'visitor')
) t1 (UserID, UserName)
)
SELECT * FROM NewUsers