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]] 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.
