|
Why wait? I've been working with 7.5 for a
while and it is great! Sign up as a beta tester and use the new JUMP and
JUMPTO property commands for your immediate needs. -istantaneous row access in a
data set and NO flickering!
----- Original Message -----
Sent: Monday, April 11, 2005 10:27 AM
Subject: [RBG7-L] - Re: Editing Prev/Next - a solution
Thanks David. After posting, I realized I didn't give
proper credit: the technique was suggested by Larry Lustig and others during the
discussion last fall; his concern was that the performance would be
unaccepatble. But this is for a small database so the response to PROPERTY
... 'NEXT' loop is instantaneous. And it is straghtforward - uses the DB
Navigator control and works directly on the table, no projecting, appending,
joining or deleting. Many others offered suggestions for which I am
grateful and it was due to the number of responses at that time that I thought
my current post would be helpful. ...or wait til 7.5
:)
Doug
David M. Blocker wrote:
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!!!
-----
Original Message -----
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.
|
