Razzak, I tried your suggestion and the fields still were blank. However when I started typing in one of the fields, the new information came up. Maybe the form variables are the problem because I have some fields based on variables (such as #DATE, #TIME, etc) I do use a RECALC VAR after the table reopens.
Anything else your crystal ball might show me? James Belisle Making Information Systems People Friendly Since 1990 [cid:[email protected]] From: [email protected] [mailto:[email protected]] On Behalf Of A. Razzak Memon Sent: Tuesday, November 29, 2016 8:47 AM To: [email protected] Subject: RE: [RBASE-L] - Change the Where Clause from a Button on the Form Jim, Without knowing all details on your end (not being on my radar nor in my crystal ball), I suggest the following sequence to see what you get. -- Start PROPERTY TABLE tWkInvTbl 'CLOSE' UPDATE tWkInvTbl SET ..... PROPERTY TABLE tWkInvTbl 'OPEN' RETURN -- End Notice the correct sequence and the elimination of PROPERTY TABLE tWkInvTbl 'REFRESH' command. Hope that helps! Very Best R:egards, Razzak At 09:36 AM 11/29/2016, Jim Belisle wrote: >Razzak, > >Back in April you had responded tothis question. >I have a similar situation. >I take info from a temp table, after inserting it into a permanent >table, and change a few fields >in the form. >I used this code but all I get are blank fields. >I checked the temp table after getting out of the form and the new >information is in there. >Here is the code I use after changing about three of the fields. > >UPDATE twkinvtbl SET workdatetime = .vtstart, workempid = .vewidnum, >procnum = NULL, + >partnum = NULL, typeinv = NULL, location = NULL,stime = .#TIME, comppcs = NULL >PROPERTY TABLE twkinvtbl 'REFRESH' >PROPERTY TABLE twkinvtbl 'CLOSE' >PROPERTY TABLE twkinvtbl 'OPEN' > >Any blues clues for me? > >James Belisle > >Making Information Systems People Friendly Since 1990 > > >-----Original Message----- >From: [email protected]<mailto:[email protected]> >[mailto:[email protected]] On >Behalf Of A. Razzak Memon >Sent: Saturday, April 30, 2016 7:51 PM >To: [email protected]<mailto:[email protected]> >Subject: Re: [RBASE-L] - Change the Where Clause from a Button on the Form > >At 07:06 PM 4/30/2016, Paul Buckley wrote: > > >I'm using the latest 9.5(64) and I'd like to open a form normally using: > >Edit Using Form1 where column1 = 'A'. Then from a button (or whatever) > >on the form change the where clause and refresh the data, i.e. where > >column1 = 'B' Any blue's clues would be greatly appreciated. > > >Paul, > >Use the PROPERTY TABLE tablename 'CLOSE' and PROPERTY TABLE tablename 'OPEN' >to accomplish your goal to re-populate data. > >Feel free to reach out to me with any questions or if you need an >example to illustrate the >use of such PROPERTY command. > >Very Best R:egards, > >Razzak -- You received this message because you are subscribed to the Google Groups "RBASE-L" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]<mailto:[email protected]>. For more options, visit https://groups.google.com/d/optout. ________________________________ -- You received this message because you are subscribed to the Google Groups "RBASE-L" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. For more options, visit https://groups.google.com/d/optout.
