Translating with DrWatson… this can take a few seconds the first time.
This is a genuine, complex translation. DrWatson protects commands, error codes, and log output while naturally translating the surrounding text. It’s translated once and saved.
Jim Gordon — — source: Informix-list mailing list archive (1991-1998)
} Subject: Re: interval type
} Bert Fonde writes:
} ->
} ->Is their a way to add differently defined interval types ?
} ->The manual says no but I am looking for a work around.
} ->
} ->I have variable in my table defined as interval hour to second, then
} ->in my 4gl report section I define calltotal as interval hour(5) to second.
} ->
} ->I would then like to do
} ->
} ->let calltotal = calltotal + rpt.callDuration
} ->
} ->However I get a runtime error of
} ->FORMS statement error number -1266.
} ->Intervals or Datetimes are incompatible for the operation.
} ->
} ->Can I convert some how ?
Have a look at the extend function. You use this to change the definition of a
datetime or interval field to make it match other datetime and interval fields
to allow calculations and reformatting.
Cheers - Jim
--
-----------------------------------------------------------------------------
Jim Gordon DHL Airways Inc. jgordon@us.dhl.com
-----------------------------------------------------------------------------
My opinions are my own. They may vary with time but they remain mine!
We use strictly necessary cookies to make this site work. With your
consent we’d also use optional cookies for analytics and marketing. You can accept all,
reject all, or choose. Read our Cookie Policy.