I personally take the view and project it to a temp table and refresh from there. I am sure others have their own preferences, however I like a static (well static at the moment to me) table I can review temp or otherwise, that I can review and query just to check data etc…
Sincerely, Paul D. From: [email protected] [mailto:[email protected]] On Behalf Of [email protected] Sent: Monday, April 05, 2010 10:59 AM To: RBASE-L Mailing List 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
