Using a single table view (make that a temporary view that is defined in
both the onbefore start and the on before design EEPs)
Then instead of a table refresh, in whatever button you would press to
refresh it, do this:
PROPERTY table tvwTemporaryView 'CLOSE'
DROP VIEW tvwTemporaryView
CREATE TEMP VIEW tvwTemporaryView AS SELECT * FROM WhateverTable +
WHERE (WhatEverColumn = .vWhatEverVariable)
PROPERTY table tvwTemporaryView 'OPEN'
I use this all the time. No Probs.
> -----Original Message-----
> From: [email protected] [mailto:[email protected]] On Behalf Of Dick
> Fey
> Sent: Friday, October 25, 2013 2:36 PM
> To: RBASE-L Mailing List
> Subject: [RBASE-L] - Changing DB Grid results within a form
>
> Still unable to find success, tried both suggestions to no avail.
> Tried using a view, and enclosing the var in () Jump in if you are
> doing this with success.
>
> Dick Fey
> Carpet Broker Inc.
>
>
>
>
> Can't decide if my brain is fried, or this just won't work.
>
> I want to edit a table using a DB Grid, in a form, using a variable to
> define the results shown
>
> Like;
>
> Set var vcode Text = 'SHAW'
> Edit using mfglist where mfg contains .vcode
>
>
> Then in the form, change the value of vcode, and do a property table
> refresh.. and get a new set of results.
>
> Does not work. Can it work ? What am I doing wrong?
>
> Dick Fey
> Carpet Broker Inc.
>
> --- RBASE-L
> ================================================
> TO POST A MESSAGE TO ALL MEMBERS:
> Send a plain text email to [email protected]
>
> (Don't use any of these words as your Subject:
> INTRO, SUBSCRIBE, UNSUBSCRIBE, SEARCH,
> REMOVE, SUSPEND, RESUME, DIGEST, RESEND, HELP)
> ================================================
> TO SEE MESSAGE POSTING GUIDELINES:
> Send a plain text email to [email protected] In the message SUBJECT,
> put just one word: INTRO
> ================================================
> TO UNSUBSCRIBE:
> Send a plain text email to [email protected] In the message SUBJECT,
> put just one word: UNSUBSCRIBE
> ================================================
> TO SEARCH ARCHIVES:
> Send a plain text email to [email protected] In the message SUBJECT,
> put just one word: SEARCH-n (where n is the number of days). In the
> message body, place any text to search for.
> ================================================
