Alistair -
I am unable to replicate your ifnull problem here. It works just
fine. Suggest looking at variable types to make sure you aren't trying to
put a date in an integer or something like that.
Bernie
========================================
At 05:31 PM 10/15/2001 +0100, you wrote:
>I have two - hopefully - quick questions:
>
>Firstly, why on a form in v6.5++ for Windows does the date field _seem_ to
>have to be approximately twice the size that it should have to be?
>
>For example: I have the date display format set to "WWW+ DD MMM+ YYYY" which
>at the R:> prompt, for today, gives "Monday 15 October 2001" - perfect and
>as expected.
>
>However, on a form I have to place a field that is nearly twice the size
>that is taken up by the row of ***** that is produced when the field is too
>small before I get the date displayed properly. The box is then half-empty
>something like this:
>
>-----------------------------------------------------
>| Monday 15 October 2001 |
>-----------------------------------------------------
>
>If I make the box only fractionally smaller I get something like this:
>
>--------------------------------------------------
>| *************************** |
>--------------------------------------------------
>
>
>Secondly, when using the function IFNULL I want to return a null in a
>variable if the tested column is null and perform a calculation if it is not
>null.
>
>If I use (IFNULL(Column, -0-, (Column + 2) )) I get an error or with
>(IFNULL(Column, Null, (Column + 2) )) I get a zero when the column is null
>and the calculation is fine when the column is not null.
>
>The column is actually a date column and the calculation is slightly more
>complicated than the example and returns an integer.
>
>I want to display nothing in the variable field if there is nothing in the
>column and only show the result when there is one.
>
>Any ideas anybody?
>
>
>Thanks in advance for any enlightenment,
>Regards, Alastair.
>
>
>
>A D B Burr,
>St. Albans, UK
>
>
