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

auto insert - user defined aliases are ignored

I have

name alias
issue iss

set up in the options dialog.

When I type "issue" it puts "i" at the end instead of iss (when selecting with autocomplete)

If I don't select the table using autocomplete then it doesn't put anything (by design?)
austrianfoodispuke
0

Comments

1 comment

Sort by
  • tanya
    Hello,

    User-defined aliases are case sensitive, i.e. if you table name is recorded as Name in the database, then typing name in the user-defined alias will not get the user defined alias to work for that table 'Name' in your queries.

    And yep, alias assignment works only on using auto-completion. I presume it was part of the design but I should admit that I am not entirely sure on that end!

    Thanks,
    Tanya
    tanya
    0

Add comment

Please sign in to leave a comment.