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]] On Behalf Of A. Razzak Memon Sent: Saturday, April 30, 2016 7:51 PM To: [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]. 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.
