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]
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: <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]
>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].
For more options, visit
<https://groups.google.com/d/optout>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
<mailto:[email protected]>[email protected].
For more options, visit
<https://groups.google.com/d/optout>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.
