Joe, How are you 'updating' the table, via buffering or a transaction? IOW, seems like the update is delayed somehow, so it wipes out whatever your method did. I don't do buffering or transactions, but one idea that occurs to me is to set a form.property .T. when the column changes, and have the update call the adjustment if the property is set.Are the values the proc adjusts fields in the table? Does the update overwrite them? Dan
> Date: Wed, 4 Jun 2014 13:26:39 -0400 > Subject: How to trigger an update in a grid > From: [email protected] > To: [email protected] > > Scenario: > > - A table with a logical column for selected rows > - A grid with a table as the ControlSource > - The grid has a checkbox for the selected column > - Any change in the selected column needs to call a procedure that scans > the table for selected records and adjusts values and controls based on > what it finds > > I have everything working except the automatic triggering of the procedure. > I have tried it in the Click, InteractiveChange, and Valid events of the > checkbox on the grid. The procedure runs but it seems to do so before the > table has been updated. > > How can I have the procedure run after the table has been updated? Another > approach? > > Ultimately I need to expand the update routine to change the criteria of > the records that display in the grid. I was expecting to do this by > changing the setting of a filter but I could change over to using a cursor > and create a new one each time there is a change in the selected items. > Does this sound feasible in a grid or should I change to a different > approach? > > Thanks in advance, > > Joe > > > --- StripMime Report -- processed MIME parts --- > multipart/alternative > text/plain (text body -- kept) > text/html > --- > [excessive quoting removed by server] _______________________________________________ Post Messages to: [email protected] Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/[email protected] ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
