Can't edit a table when partition is specified
Posted: Wed 06 May 2009 16:07
Hello,
I have this query in a TSmartQuery which is attatched to a TDBGrid.
select h.rowid, h.* from hash_part
PARTITION (SYS_P2063) h
The table definition does not matter - any partitioned table will do.
Then I try to make an edit in the grid, post, commit, and run the query again. The data has not been posted because no update statement was ever issued.
-John
I have this query in a TSmartQuery which is attatched to a TDBGrid.
select h.rowid, h.* from hash_part
PARTITION (SYS_P2063) h
The table definition does not matter - any partitioned table will do.
Then I try to make an edit in the grid, post, commit, and run the query again. The data has not been posted because no update statement was ever issued.
-John