Refresh records

[Tim Cummings]

Ti kanete,

I have faced this problem in the past and have a partial solution.   When
you set-up your ACCESS statement, add an additional SELECT condition that
evaluates a unique value on the table in question.  This will allow you to
use the original find characteristics and then read and discard until you
find the record in question.  Then reset the temporary (in the postfind)
that were used to do the read and discarding.  Your ACCESS/SELECT  would
look something like this:

FILE CUSTOMER
ACCESS . . .
SELECT IF T_UNIQUE_VALUE = CUST-CUSTOMER-ID OR T_UNIQUE_VALUE = " "

PROCEDURE POSTFIND
  BEGIN
     LET T_UNIQUE_VALUE = " "
  END


When you use the technique discussed by the other contributors along with
the above SELECT, the PUSH FIND will then put you at the same point in the
chain of records that you were before.  When the user presses next record
the original chain will be resumed.  The only draw back to this approach is
if a select was used from the action line.

Good luck,

Tim Cummings
Cummings Consulting
6301 Arrowpoint Drive
Loveland, OH  45140
513-576-1182

-----Original Message-----
From: powerh-l-admin@cube.swau.edu [mailto:powerh-l-admin@cube.swau.edu]On
Behalf Of Andreas Argyriou
Sent: Wednesday, May 08, 2002 11:09 AM
To: Powerh-L (E-mail)
Subject: RE: Refresh records

Hello everyone,

I have had a similar problem recently which has an extra twist.
The user has executed a find which returns many records (this is a
single-record screen). After examining a few records they decide to execute
a designer procedure which calls a stored procedure (Oracle). The procedure
changes one of the fields displayed on screen. If I execute a PUSH FIND
(invisible to the user) I can display the field that has changed. However, I
will interrupt the original find chain and when the user presses next record
the program will behave as if the original find chain had ended.

I don't think there is something that can be done about it.

What I decided to do was to use a temporary item that will carry the value
of the field that changes and to maintain it using a designer alias for the
primary file. This way I will avoid the PUSH FIND. Fortunately the specific
screen does not perform any other actions.

Any comments are welcome.

TIA and regards
Andreas Argyriou
Scicom S.A.
Athens, Greece


-----Original Message-----
From: Markus Grossrieder [mailto:markus.grossrieder@alba-systems.com]
Sent: Thursday, May 02, 2002 6:55 PM
To: PowerHouse List (E-mail)
Subject: Refresh records


Hi list,

is there a way to refresh records shown in a Quick screen, after they are
updated by an other program (say, a QTP), without doing a find again ?

(Powerhouse  7.10.G3, OpenVMS V7.2-1)

TIA, regards,

Markus


= = = = = = = = = = = = = = = = = = = = = = = = = = = =
Mailing list: powerh-l@lists.swau.edu
Subscribe: "subscribe" in message body to powerh-l-request@lists.swau.edu
Unsubscribe: "unsubscribe" in message body to
powerh-l-request@lists.swau.edu
http://lists.swau.edu/mailman/listinfo/powerh-l
This list is closed, thus to post to the list you must be a subscriber.

= = = = = = = = = = = = = = = = = = = = = = = = = = = =
Mailing list: powerh-l@lists.swau.edu
Subscribe: "subscribe" in message body to powerh-l-request@lists.swau.edu
Unsubscribe: "unsubscribe" in message body to
powerh-l-request@lists.swau.edu
http://lists.swau.edu/mailman/listinfo/powerh-l
This list is closed, thus to post to the list you must be a subscriber.