September 24, 200817 yr I have 2 tabs. On each tab I have a table occurrence for the primary parent table and a table occurrence for the child table. When I delete a record from the child table portal and click the other tab - the record still shows in the portal UNTIL I click on the layout and then the screen will refresh and the record disappears. I'm using the Refresh button with the cached join option. Any ideas?
September 24, 200817 yr I am not sure what your issue is. When you delete a portal row, the parent record is modified, but the modification is not finalized until you commit the record (for example by clicking on the layout's background). Until then, the changes can be reverted. Another thing is that portal data is cached, and the cache will not be refreshed until the record is committed (sometimes not even then). So if you have a portal to another occurrence of the child table, it will continue to show the "deleted" child record, until the parent record is committed. The tab object is irrelevant here - you will see the same thing if you place the portals side-by-side.
September 24, 200817 yr Instead of using the native tabs to navigate between tab panels, name those tab panels as objects and set their tabs to 0 width. Create text boxes with the tab names and make them buttons. Set the script to select the tab panel you want (Go To Object) and also Commit and Flush Results if necessary.
September 24, 200817 yr Wouldn't it be simpler to have a button in the portal that deletes the portal row AND commits the record?
October 1, 200817 yr Author Thank you very much. I'm always thinking 4D and didn't remember to "commit" after the deletion. Thanks.
Create an account or sign in to comment