No suggestions table function without alias

Maurice

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!



When using an alias the appear.

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

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.

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

Aaron L

Awesome!

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

Thanks again!
Aaron.