SqlDbx Forum

gworona

Member

Modify Table Data not working

I can't seem to enter table edit mode. When I click modify table data I get the message, "Table unique key column(s) not included in query: ROWID".  What do I need to do differently.

Here's what it looks like: https://dl.dropboxusercontent.com/u/420 … hot018.jpg

sqldbxhelp

Administrator

Re: Modify Table Data not working

In order to modify table with unique or primary key it has to be selected.
I do not understand but somehow hidden ROWID is a unique or primary key in your case.
If this is the case than it's really bad idea.
If you want to modify table like that you will need to run
SELECT rowid, * FROM gsa_ref_lines and the right click in results and select "Modify Table Data"