Very interesting concept. As is most often the case there is more than one way to get the desired result. I will have to try this.
James Belisle Making Information Systems People Friendly Since 1990 -----Original Message----- From: [email protected] [mailto:[email protected]] On Behalf Of MikeB Sent: Friday, October 25, 2013 2:18 PM To: RBASE-L Mailing List Subject: [RBASE-L] - RE: Changing DB Grid results within a form 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. > ================================================
