Advanced Query Improvements

By Carlos Henriques on 5 Apr 2011
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.
Adam Alt7 Apr 2011
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.
Kilian Hekhuis25 May 2011
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.