[RBG7-L] - Re: Editing Prev/Next - a solution

[David M. Blocker]

Doug   Very slick!   Just got back from an amazing first ever R:Chautauqua training for Authorized Developers.  Now wait til you see the newest amazing property command coming in 7.5 to help you do the same thing!!!    David Blocker [EMAIL PROTECTED] 781-784-1919 Fax: 781-784-1860 Cell: 339-206-0261 ----- Original Message ----- From: Doug Hamilton To: RBG7-L Mailing List Sent: Friday, April 08, 2005 12:23 PM Subject: [RBG7-L] - Editing Prev/Next - a solution Some time ago I posed the following scenario: I have an EDIT USING FormName that edits one row in a table selected from a CHOOSE command. Any ideas on how to edit that selected row but still use Next & Previous buttons in DB Navigator to edit the other rows in the Choose command so we don't have to go back to CHOOSE command to select again? It's been sort of a low priority and maybe somebody else has figured it out since, but here's what I got to work for me.   Basically, start at the first row and use an On-After-Start EEP to increment through till you get to the record you want.  Then you can Next/Prev/First/Last through all the rows in the WHERE clause.   If I may humbly quote,  "Here's how: " 01.  Identify the specific row to edit from a subset of the table.  i.e.  John Smith is CustID number 456 of all the Smiths, vCustID = 456. 02.  EDIT USING CustMaint WHERE &vWhere ORDER BY FirstName         In this case, vWhere is    LastName = 'Smith' 03.  Form CustMaint has an epxression: vfCustID = CustID 04.  Form CustMaint has an On-After-Start EEP that increments through the Smith's till we get to John, # 456:     WHILE vfCustID <> .vCustID THEN       PROPERTY TABLE CustList  'NEXT'     ENDWHILE     RETURN 05.  From here,  the buttons on a DB Navigator bar work just fine: Next brings up Kevin Smith, Prev = Igor Smith, First = Abe Smith and Last = Zeke Smith. Hope this helps someone and thanks to all for your help. R:egards, Doug ok, I admit, I'm embarrassed at how simple this turned out to be.