Dennis, you need to first tell the form what the value of eqphigh is
Define a variable with the value of eqphigh in the Variable list of the form
v_eqphigh = eqphigh FROM eqphigh <where clause>
Now you next define the variable for the value of the column. It must be
below the v_eqphigh variable in the list.
begeqp = (IFNULL(begeqp,.v_eqphigh,begeqp))
You may also need to define an EEP on the ROW entry or on the column
field entry.
RECALC VAR
RETURN
Albert
On 18/07/2014 10:45 AM, Hodges, Dennis wrote:
I have a column in my table that contains the Beginning Equipment
Usage (begeqp). In my Edit form I want to set the begeqp to the high
usage value (eqphigh) of the eqphigh table, otherwise I want to use
the current value of begeqp. I tried using IFNULL as shown below:
(ifnull(begeqp,eqphigh,gegeqp)) FROM eqphigh where dotnum eq
dotno,begeqp))
And got the following error.
The first and last arguments for IFNULL must be the same type. )2155)
They are not only the same type, they are the same variable.
How can I do this?
Thanks,
*Dennis Hodges*
Maintenance Management Manager
FDOT Office of Maintenance MS #52
PH: (850) 410-5635
FAX: (850) 410-5511
[email protected] <mailto:[email protected]>
Please note: e-mail may be subject to public disclosure.
