How can we help you today? How can we help you today?

problems with table alias handling

if i get to the point of having this query
---
SELECT
FROM dbo.CONTRACT ORD (NOLOCK)
INNER JOIN dbo.CONTRACTITEM ITM (NOLOCK)
ON ( ORD.CONTRACTNO = ITM.CONTRACTNO )
INNER JOIN dbo.Master MI (NOLOCK)
ON (ITM.masterno = MI.masterno )
WHERE DATEDIFF(DAY, ORD.adddate, GETDATE()) = 0
AND ord.STATUSCODE NOT IN ( 'CANCELLED' )
AND ORD
---
and i just finished typing the D or "ORD" on the last line, i will have a candidates list showing things like ORDDATE (a column in a table in the db). in v2 of prompt, i could type a period to indicate that i wanted to use the alias ORD. in v3, if i type the period, i get the "current" item listed in the candiate list. it takes a few keystrokes to avoid this happening
jjderoo
0

Comments

3 comments

Sort by
  • Tilman
    Hi,

    have you tried switching off '.' as a completion key? You can do this on the Candidates tab of the Options dialog.

    Regards,

    Tilman
    Tilman
    0
  • jjderoo
    that does not seem to make a difference - i think this is more a side effect of not having at least one column named between SELECT and FROM

    when i have a column in the select list, the candidate list is less confused
    jjderoo
    0
  • Tilman
    Yes, I would suggest at least putting a '*' there, don't leave it empty. The more valid your SQL is, the better Prompt will work.

    Tilman
    Tilman
    0

Add comment

Please sign in to leave a comment.