Bob, I have switched most of my db-grids out so I'm not sure I have this correct. I think this is a time where you drop your created view, re-create your view with the new where clause and refresh the list.
Something like PROPERTY TABLE yourview 'CLOSE' DROP VIEW yourview CREATE TEMPORARY VIEW yourview + AS SELECT + ..... all of your stuff here PROPERTY TABLE yourview 'OPEN' PROPERTY TABLE yourview 'REFRESH' Jan -----Original Message----- From: [email protected] To: [email protected] (RBASE-L Mailing List) Date: Mon, 5 Apr 2010 14:59:14 +0000 (UTC) Subject: [RBASE-L] - Refresh DB grid ... mental block I have probably done this several times before, but for some reason I cannot remember how nor get this to work... a simple function, but it is Monday.... I have a simple form with a DB grid. The form and DB grid is based upon a VIEW. The form is called via a form EEP : brow USING DevItemReserve WHERE currentitem = .vItem and serial# in + (Select Serial# from skiddata where item = .vItem and onhold <> 1) The DevItemReserve form has a button that can place the ONHOLD value = 1 in SkidData for the highlighted row being displayed. This all works as desired except I want to refresh the form/DBGrid so that selected row does not show anymore. Form A has an button eep that issues the above browse command. This lists the rows of data that is not reserved (Onhold <> 1). The user can highlight a row and push a button which updates the ONHOLD value in SkidData to 1 for that row. The DB grid ID is ItemList I now want the form to refresh and not show the just updated row. I have tried several iterations of PROPERTY posts, refresh, refreshlist, etc. etc. but am missing the correct one. Remember, the form and DB grid is based upon a multi table view. The where clause, however, has the table that is updated. Don't know why I cannot get this... mark it to Monday. Thanks, -Bob
