Alastair,
01. Form: Date Field Object Width
I would check the date field object properties for:
. Font
. Font Style
. Font Size
Try the default MS Sans Serif, Regular, Size 8 and
see what happens.
02. IFNULL Function
Syntax: (IFNULL(arg1,arg2,arg3))
If arg1 is null, then the value of arg2 is returned.
If arg1 is not null, then the value of arg3 is returned.
The value of arg2 and arg3 may be nested functions to
provide enhanced capability.
If you can provide an example using CONCOMP database, we'll
probably find an answer for you.
For a complete list of all functions with examples, please
refer to http://www.RSyntax.com >Syntax >Functions
Very Best Regards,
Razzak.
At 05:31 PM 10/15/01 +0100, Alastair Burr wrote:
>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?
>
>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.
===================================-============================
Official R:BASE List Server: mailto:[EMAIL PROTECTED]
RBTI Events/Training: http://www.rbase2000.com/events
R:DCC Members: http://www.rbase2000.com/rdcc
================================================================
R:BASE, Oterro & R:Tango are registered trademarks of RBTI.
==================================-=============================
