AWESOME ! Thanks so much. I love this list
Dick Fey Carpet Broker Inc. On 10/25/2013 2:17 PM, MikeB wrote:
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. ================================================
