auto insert - user defined aliases are ignored
austrianfoodispuke
Posts: 100
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?)
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?)
Comments
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