Hi Alistair, I have no solution for your first problem. Pertaining to the second problem- I believe I ran into this before. The IFNULL function worked fine on a Win98 workstation but choked on on a WinNT workstation and I had to find a workaround. What operating system are you having problems with?
Best regards, Mike Young On Mon, 15 Oct 2001 11:28:24 -0700 (PDT), Bernie Corrigan wrote: >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 >> >> >
