0
 Followers
10
 Likes

Advanced Query Improvements

Aggregates & Queries
On our radar
Service Studio advanced queries verifying engine needs some improvements.
With more complex queries it fails, generating eSpace warnings for perfect SQL syntax.

Example:
A delete statement with an inner join

DELETE C
FROM CUSTOMERS C
INNER JOIN TYPES T ON (T.ID = C.TYPEID)
WHERE T.CODE = 'XPTO'

First it doesn't like the alias. Then, if I replace the alias for the table names it doesn't like the keywords "inner" and "join".

The same happens with the "EXEC" command.
Created on 5 Apr 2011
Comments (2)
Yeah, it gives you a warning for having EXEC in an advanced sql statement.

Also sometimes it fails out when I try to enter text to test the query with in the test input tab.
What about auto completion? Or has this been implemented in 5.1 already (still using 5.0)? It knows the table names, and all the field names, but I have to type the darn things from a to z...

Also, the possibility to Verify and show more than the first error. I have many queries that use SQL-strings as input, which are then injected into the main SQL, which causes verification failure, so I can't check any further.

Also, allow for queries without output. Very handy for UPDATEs etc.

Also, better alias handling. Sometimes you need aliasses (e.g. when joining the same table twice), and doing a ALIAS.* gives warnings about number of columns that can't be checked etc.
views
109
Followers
0