Posts
Sort by recent activity
Updates with fields losing table context
I started with the following statement:UPDATE Table SET
Complete = 0,
UpdateCustomer = 1,
UpdateMember = 1,
Update
If i press the hotkey when i've typed the word "upd" it will work correctly ...
List of bugs
Can a sticky please be created with a list of all found bugs?
Its hard to go through the forum and see which have or have not been found and the common ones have 3-4 posts each reporting the same i...
Feature request: local variables
This isn't a bug, but just a nice to have.
DECLARE @... [ctrl-space]
Should come up with a list of types.
Variables should come up in candidate list for joins, fields, etc once created.
One other t...
OR statement and tables starting with same letter
If you type:WHERE (1 = 1 or
And pause for a second after typing "OR" the candidate list will pop-up. If you have a tabled named "order" or something starting with "or" when you press the spac...
Selecting view on join didnt complete text
While editing a proc.
I had the following bit of code (in a more complex proc):
LEFT JOIN cus_Customer C ON C.CustomerID=M.CustomerID
LEFT JOIN sec_Person P ON N.ActionedByID=P.PersonID
INNER JOIN ...
Keyboard navigation shortcuts cause exception
This doesnt happen all the time, but does happen a fair bit. If it happens to a particular bit of code, it will also happen in that window.
When having a script open.
eg. A stored proc with 20 line...
Alias needs to appear in where columns
If i type the following:SELECT *
FROM cus_Customer C
WHERE
The candidate window will pop up.
If I then type "C.", it will give a list of all objects starting with C, and when i press . it will se...
Insert statement - candidate list appearing when shouldnt
If i type a space after closing an insert statement field-list, it will still bring up the candidate box when it's not meant to appear.INSERT into cus_Customer (FirstName, LastName)[spa...
First Fieldname in Insert statement failing
The first field of an insert statement seems to fail.
If i type:INSERT into cus_Customer (FirstNa[space]
(An empty box will come up)
Anything else will work after the first field:INSER...
Alias duplicates on select statement
If i do a select statement from a table with the alias, then later try to add columns to the select, the alias will duplicate.
If i type the first few characters of the field it will work fine, if ...