First off I have to say great job on the new version. It is leaps and bounds better than the old version and I'm really liking what I am seeing so far.
One thing I am currently running across during my testing is when creating a derived table the intellisense stops working correctly. I get the popups still but I do not receive the items that I would expect in the list.
Ex:
UPDATE IT
SET PayTotal = SumDT.PayTotal
FROM InvTotals IT
INNER JOIN (
SELECT S.InvID,
SUM(P.Amt) AS PayTotal
FROM Sales S
INNER JOIN Payments Pay
ON s.SalesID = Pay.SalesID
GROUP BY S.InvID
) SumDT
ON IT.InvID = SumDT.InvID
When I type "Pay." I get the select list but it does not contain the Payments table columns in the select list.
If you comment out everything but the inner select it all works correctly but inside the parens it does not work as expected.
Travis DeAngelis
Sr. Software Engineer
AdvancedMD Software
One thing I am currently running across during my testing is when creating a derived table the intellisense stops working correctly. I get the popups still but I do not receive the items that I would expect in the list.
Ex:
UPDATE IT
SET PayTotal = SumDT.PayTotal
FROM InvTotals IT
INNER JOIN (
SELECT S.InvID,
SUM(P.Amt) AS PayTotal
FROM Sales S
INNER JOIN Payments Pay
ON s.SalesID = Pay.SalesID
GROUP BY S.InvID
) SumDT
ON IT.InvID = SumDT.InvID
When I type "Pay." I get the select list but it does not contain the Payments table columns in the select list.
If you comment out everything but the inner select it all works correctly but inside the parens it does not work as expected.
Travis DeAngelis
Sr. Software Engineer
AdvancedMD Software