Enhancement req. - Edit data without using table alias.

[Paul Ljungqvist]

As far as I know, there is only one way to use the 'Edit Data' button.
There must be a table alias, and specificly also query for rowid.
A lot of our developers has complained about the lack of posiblity to edit data without using rowid and table alias.
Could this be changed in some way?

This does not work:
SELECT * FROM tab1 t WHERE col1 = 'something'

This does:
SELECT t.*, t.ROWID FROM tab1 t WHERE col1 = 'something'

 

[Harry MacDonald]

This will work without the rowid:

SELECT * FROM tab1 t WHERE col1 = 'something' FOR UPDATE;

HMD