|
Randy: I could have sworn that I tried the MIN command and I
could not get it to work, I will have to try it again. No, my form is actually using the actual columns so the RECALC
variables will not work. It sure would be a nice upgrade to have a “REFRESH
FORM” command…ah well…maybe 7.0 will have it. Thanks for the help, 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 -----Original
Message----- 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 -----
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 |
- [RBASE-L] - Re: Questions on forms, bugs... randyp
- Javier Valencia
