Alastair - For your second question, if your ZERO setting is ON, then NULL evaluates to 0. If you want it to evaluate to NULL then SET ZERO OFF.
Sami ----- Original Message ----- From: "Alastair Burr" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Monday, October 15, 2001 11:31 AM Subject: Date fields in forms & ifnull return null questions > 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 > > > >
