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

No suggestions table function without alias

Hi,

Just updated to SQL Prompt is 6.4.0.631 and found a feature :)
When I use a table function without an alias the columns as not showing in the where statement. It used to work without an alias, it showed the functionname as objectname. In the Select (Tabbing the asterix) it works without a problem!

1tBlNic.png

When using an alias the appear.

GSfcWJe.png
Maurice
0

Comments

4 comments

  • Aaron L
    Hi Maurice,

    Thanks for letting us know about this! I can recreate it locally and will try to get a fix out for you as soon as possible. I just gave it a try in 6.3 and it doesn't work there either so it looks like it might have been broken for a while.

    Thanks,
    Aaron.
    Aaron L
    0
  • Aaron L
    Hi Maurice,

    I think I've got a fix for you in this private build if you'd like to give it a try?

    Thanks,
    Aaron.
    Aaron L
    0
  • Maurice
    Aaron Law wrote:
    Hi Maurice,

    I think I've got a fix for you in this private build if you'd like to give it a try?

    Thanks,
    Aaron.

    Hi Aaron,

    Thanks for the quick fix! It works perfectly now :)

    phCmLHq.png
    Maurice
    0
  • Aaron L
    Awesome!

    I'll make sure the fix is included in our next stable release.

    Thanks again!
    Aaron.
    Aaron L
    0

Add comment

Please sign in to leave a comment.