Dick:
Your approach refreshes the values in the table but it does not re-define
the CLAUSE. The only way I know how to do this is to use a temporary view
and after you do your changes you need to close it, re-define with the new
clause and re-open the view.
Here is a snippet of code I call from an EEP to redefine the clause:
-----------------------
SET VAR vquote = (CVAL('QUOTES'))
SET VAR vseg_id_search = (.vquote + '%' + .vseg_id_search + '%' + .vquote)
SELECT COUNT seg_id INTO vcount FROM features +
WHERE seg_id like &vseg_id_search
IF ( vcount > 0 ) THEN
PROPERTY TABLE x_feat 'CLOSE'
DROP VIEW x_feat
SET VAR vDefineView = ('CREATE TEMPORARY VIEW x_feat AS SELECT')
SET VAR vDefineView = +
(.vDefineView & 'sub_sys,seg_id,road_name AS xroad_name' +
& 'FROM features WHERE seg_id LIKE' &.vseg_id_search +
& 'ORDER BY sub_sys ASC, seg_id ASC')
&vDefineView
PROPERTY TABLE x_feat 'OPEN'
ELSE
PAUSE 2 USING 'No records found that meet the search criteria...'
SET VAR vseg_id_search = ' '
RECALC VAR vseg_id_search
ENDIF
LABEL Done
RETURN
----------------------
Javier Valencia
913-915-3137
-----Original Message-----
From: [email protected] [mailto:[EMAIL PROTECTED] On Behalf Of Dick Fey
Sent: Monday, October 06, 2008 12:41 PM
To: RBASE-L Mailing List
Subject: [RBASE-L] - RE: Brain on hold?
Interestly ... the CLOSE removes the visible rows, but upon OPEN,
even though the value for vstyle has been changed, the original
rows re-appear.
If you leave the form, or do a trace, the value for vstyle is the new value.
Bottom line is that I want to change the rows I am editing in the form from
the form,
rather than going out and entering a value then loading the form each time.
PS: Try saying form from the form 5 times!
Dick
----- Original Message -----
From: "Emmitt Dove" <[EMAIL PROTECTED]>
To: "RBASE-L Mailing List" <[email protected]>
Sent: Monday, October 06, 2008 12:14 PM
Subject: [RBASE-L] - RE: Brain on hold?
> Dick,
>
> Try this sequence:
>
> PROPERTY TABLE tablename 'CLOSE'
> -- now change the value of vstyle
> RECALC VARIABLES
> PROPERTY TABLE tablename 'OPEN'
>
> I'm just guessing here ... I know this will work to refresh a scrolling
> region that is based on a temp table or view.
>
> Emmitt Dove
> Manager, DairyPak Business Systems
> Evergreen Packaging, Inc.
> [EMAIL PROTECTED]
> (203) 214-5683 m
> (203) 643-8022 o
> (203) 643-8086 f
> [EMAIL PROTECTED]
>
> -----Original Message-----
> From: [email protected] [mailto:[EMAIL PROTECTED] On Behalf Of Dick Fey
> Sent: Monday, October 06, 2008 12:59 PM
> To: RBASE-L Mailing List
> Subject: [RBASE-L] - Brain on hold?
>
> Any ideas about why this does not work......
>
> Set VAR vstyle text = 'ABC'
> Edit using Formname where stylecode = .vstyle (using a scrolling region)
>
> Then while editing the form...
> Using a dbedit not in the scrolling region,
> Clear value vstyle
> Set new value for vstyle
> Issue 'Property Table Tablename 'REFRESH'
>
> Why does the scrolling region not refresh to the values for the new
> stylecode?
>
> Dick Fey
>
>
>
