Hello,I have been using TEE for a week now, so still very new.I was wondering, is there a way to edit a record within the Data tab of the Schema browser? I can see the edit icons, but they are grayed out.Thanks in advancevitocEdit, I just realized, sometimes I get the icons and sometimes I don't.It seems that is I have a worksheet open I don't see the icons.Also, it seems that when I click on New Editor all my editor pages contain the same code.I can't have two editors with two different codes.
Message was edited by: vitoc74
I observed the same in the past. I'm not surprised by views not being editable, as they are lacking formal primary / unique key constraints by which a record could be updated correctly.But I've also observed this behaviour in tables with multi-column primary keys. I guess those tables should be updatable, too?A table can be safely updated when:- there exists at least one primary / unique key- all columns in that primary / unique key are "not null"I've added this as an idea in Ideascale:http://toadextensionforeclipse.ideascale.com/a/dtd/Allow-for-updating-tables-with-multi-column-primary-keys/320720-9318
Hi Tomas,You're right, I wasn't looking at the full index definition. It's actually not related to the multi-column PK, but to the fact that the table is an IOT (Index Organised Table). It just happens that multi-column PK's are strongly correlated to IOT's in our DB (as probably in any DB). That's why I came to the wrong conclusion.Here are two tables that you can use for reproduction of this issue:create table x( id1 number(7), id2 number(7), constraint x_pk primary key (id1, id2) ) ORGANIZATION INDEX; create table y( id1 number(7), constraint y_pk primary key (id1) ) ORGANIZATION INDEX;CheersLukas
Thanks Tomas.However, I don't know if it's the same problem as the one reported by vitoc74. There could be other, similar issues as well...CheersLukas