Dear Javier,
You are right, the syntax is 'touchy' on this. I
thought it would be trivial, then I created a table and
tried to put a variable on the form. Whoops! It kept
saying it could not find the table or something. That's why
I have the parenthesis the way I have. I don't think I need
them surrounding my where clause, but I always put them to
enhance the calculation. But the command will not work
unless it is punctuated (MIN (proc_code_nrdg)) ...
It sounds like your form does not have a region on
it. If it has a region, sometimes the region is updated if
you go to the part of the form which is based on another
table.
If you are using an MDI form from a 'parent form'
you may be better to 'quit to' the form you now use as MDI.
Then quit back to your original form. When it reopens, all
the fields should be updated because it is opening 'new'
with the updated values. The user should not be able to
tell much difference.
All the best.
Randy Peterson
----- Original Message -----
From: randyp
To: RBASE-L Mailing List
Sent: Thursday, January 09, 2003 11:41 PM
Subject: [RBASE-L] - Re: Questions on forms, bugs...
Javier,
1. Create a form variable:
vNext_rdg = (MIN (proc_code_nrdg)) FROM fsched_file
WHERE (equip_code = .vequip_code)
2. Try RECALC VARIABLES. It should refresh your
form if it is a form using variables.
Randy Peterson
----- Original Message -----
From: Javier Valencia
To: RBASE-L Mailing List
Sent: Thursday, January 09, 2003 9:06 PM
Subject: [RBASE-L] - Questions on forms, bugs...
Is it just me or we can no longer report bugs for 6.5++?.
I tried to report a bug to RDCC but under Product, the only
option is "RBASE V7.0 for Windows - Private BETA". does this
mean that if we find a big in 6.5++ we are SOL?
Also, a couple of question on forms:
Question 1:
I have a form in which I display information on a vehicle
and I would like to display a lookup variable with the
lowest (MIN) mileage for that vehicle based on information
on maintenance intervals for different maintenance
procedures stored in a separate file (schedule). Right now I
use an eep to calculate this value on entry to the row.:
COMPUTE vnext_rdg AS MIN proc_code_nrdg FROM fsched_file +
WHERE equip_code = .vequip_code
Is there a way to define a variable in the form to do
this, without using an eep? I seem to recall doing something
similar this once upon a time, but I cannot remember exactly
how.
Question 2:
From a main form for a file that stores work order
information (one), I call (via eep) a second form for a file
that stores the manpower information for the work order
(many), when I exit the second form, the eep calculates a
summary of the labor costs and updates the work order file
(using the UPDATE. command) with these cost and returns to
the main form but the updated fields do not show the new
values. In the past I have used NEXTROW, PREVROW in the eep
to refresh the columns in the form but if I am in the last
work order record, it will return display to the previous
work order record ( NEXTROW does not do anything since is
the last record and PREVREC will skip to the previous
record). I believe that this topic has been discussed before
and I was wondering if any one came up with a solution.what
I really need is a "REFRESH FORM" type command (SAVEROW,
SETFOCUS and RECALC TABLE do not work) or any other
procedure that would force the main form to refresh.
Thanks in advance,
Javier
Javier Valencia, PE
President
Valencia Technology Group, L.L.C.
14315 S. Twilight Ln., Suite #14
Olathe, KS 66062-4571
(913)829-0888
(913)649-2904 FAX
