Thank you. I will try that. 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 9:36 AM To: [email protected] Subject: RE: [RBASE-L] - Change the Where Clause from a Button on the Form Jim, If you wish to recalculate any variable(s) defined as Form Expression(s), as you enter a row, depending on your form and all associated stuff, you may add the following code as "On Row Entry" EEP under Form Table Settings: Form Designer > Main Menu > Tables > Add or Remove Tables > Table Settings > Entry/Exit Procedures > On Row Entry > Edit Custom EEP ... -- Start SAVEROW RECALC VARIABLES RETURN -- End Razzak At 10:11 AM 11/29/2016, Jim Belisle wrote: >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]<mailto:%3ecid:[email protected]> > > >From: [email protected]<mailto:[email protected]> >[mailto:[email protected]] On >Behalf Of A. Razzak Memon >Sent: Tuesday, November 29, 2016 8:47 AM >To: [email protected]<mailto:[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: > ><mailto:[email protected]>[email protected]<mailto:[email protected]%[email protected]> > [mailto:[email protected]] On > >Behalf Of A. Razzak Memon > >Sent: Saturday, April 30, 2016 7:51 PM > >To: > ><mailto:[email protected]>[email protected]<mailto:[email protected]%[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 ><mailto:[email protected]>[email protected]<mailto:[email protected]%[email protected]>. >For more options, visit ><https://groups.google.com/d/optout>https://groups.google.com/d/optout<https://groups.google.com/d/optout%3ehttps:/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 ><mailto:[email protected]>[email protected]<mailto:[email protected]%[email protected]>. >For more options, visit ><https://groups.google.com/d/optout>https://groups.google.com/d/optout<https://groups.google.com/d/optout%3ehttps:/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]<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.
