Delete row (OpenInsight 32-bit Specific)
At 22 JUL 2010 12:59:44AM John Grant wrote:
I ran delete_row to remove some entries from a table using TCL. TCL reported success for each row as I entered the various key values, however when I run or_view '','list table I find all the data was removed, however the keys remain. What is happening and how do I remove the entries entirely. Of note the tables did have indexes on them including several relational indexes.
At 22 JUL 2010 03:29AM [url=http://www.sprezzatura.com]The Sprezzatura Group[/url] wrote:
Referential integrity demands that if a child references a parent you cannot completely delete the parent without deleting the children first so if a row has "children" defined an attempt to delete it will leave it blank with just the related keys in place. Delete the children THEN delete the parent.
World leaders in all things RevSoft
At 23 JUL 2010 03:52AM Eric wrote:
Or perform an index.flush