× Heads up!

Aqua Data Studio / nhilam

Follow
IDE for Relational Databases
×
Tariq Rahiman
tariqrahiman reported 2014-04-18T20:47:01Z  · last modified 2017-02-21T18:17:15Z

autocompletion not working for SQL Server 2000


customer request
Dev
Kin-Hong Wong
kin-hong
QA
Tariq Rahiman
tariqrahiman
Priority Low
Complexity Unknown
Component Q Analyzer - Auto-Completion
Version 18.0
Version: 14.0.11-1
Build #: 37331
Build Date: 2014-Apr-18 10:27:03 AM
 
autocompletion not working
 
Test against SQL 2000 Northwind Databasr
 
1. In the first SQL, after typing so.^ no autocompletion popup comes up. I tested this against all earlier versions till v8 and the behavior is the same.
Is it expected to display autocompletion window in this case ?
 
2. In the second SQL, after the first SELECT no popups appears even when tables are aliased properly. For so.^ and r.^ when we hit Ctrl+Space no popup appears. But within any SELECT inside the sub queries everything works fine.

SELECT
so.OrderID,
r.
FROM
( SELECT
so.OrderID , so.
COUNT(*) sos 
FROM
ORDERS so
        GROUP BY so.OrderID, so.ShipCity
) so
 
 
SELECT
so.
FROM
(SELECT
so.OrderID , so.
COUNT(*) sos 
FROM
ORDERS so 
WHERE
so.ShipCity IN (SELECT
CategoryName 
FROM
Categories 
WHERE
CategoryID=1) AND
so.OrderID > 0 
GROUP BY
so.OrderID) so 
LEFT JOIN "Order Details" r 
ON so.OrderID = r.OrderID and 
r.OrderID IN (SELECT
D.OrderID
FROM
Orders_dup D
WHERE
ShipName ='Techs')
ORDER by so.OrderID
go
 
 
//
 

 

4 attachments
  •  
  •  
  • 2 shares
  •  
All Comments (2) Change History
Sort 

Issue #11905
Closed
Fixed
Resolved 2014-10-23T17:55:57Z
 
 
Completion
No due date
Fixed Build 15.0.9-14
No time estimate

About AquaClusters Privacy Policy Support Version - 19.0.2-4 AquaFold, Inc Copyright © 2007-2017