Toad World® Forums

Editing using column alias



When making a select with a column alias in editing mode it allow the edit but gives and error afterwards …

select name, price p from article
editing the price (alias p) gives when changing line the error



Good fine, Filipe. It has been in sqlnav for a while but hasn’t been reported yet. When you make change to a column with alias, sqlnav tries to fire an update query using the alias instead of the actual column name. Hence the error that you got. Our fix would be to make columns with alias readonly so no change can be made which will avoid this kind of confusion.



Fixed in at least 1824