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