Blanks in Numeric Fields

alan_watt

Member
I want to be able to enter a Test Result into a field on a form. The value
will be a numeric value. However the problem is that the value "zero" is not
the same as the value "blank", i.e. if the result is zero, then you need to
record zero, if it's not available or is an invalid test here, then you need
"blank". As far as I can tell when you put a blank into a numeric field in
OneWorld it simply puts a zero in there. I realise I could use a string
field, but then there's all the horrors of converting between strings &
numbers. SQL Server understands the difference between Null and Zero, so I
would have thought that OneWorld could as well.

Is there a simpler way?

Cheers...

... Alan =8^)
__________________________________
Alan Watt
Jade Enterprise Solutions Ltd.
"Making Good Ideas Happen"
__________________________________
Tel/Fax: +44 (0)161 428 1288
Mobile: +44 (0)7970 255073
Email: [email protected]
URL: http://www.jade.tm
__________________________________
 
Hi!
One World also understands the difference... In case of numeric fields
between 0 and null, in case of string fields between blank and null. I guess
when you enter the form your numeric field its value is defaulted "zero". If
I had to test the result of some function I would either enter a value into
the field that is completely impossible (in most cases zero) before the
function and test against it afterwards or use some other return value of a
function or routine (for example error codes)
Hope it helps
Regards:
Gergely Pongrácz
Synergon, Hungary

> ----------
> From: alan watt[SMTP:[email protected]]
> Reply To: [email protected]
> Sent: Wednesday, December 20, 2000 3:38 PM
> To: [email protected]
> Subject: Blanks in Numeric Fields ~~0:2975
>
> I want to be able to enter a Test Result into a field on a form. The value
> will be a numeric value. However the problem is that the value "zero" is
> not
> the same as the value "blank", i.e. if the result is zero, then you need
> to
> record zero, if it's not available or is an invalid test here, then you
> need
> "blank". As far as I can tell when you put a blank into a numeric field in
> OneWorld it simply puts a zero in there. I realise I could use a string
> field, but then there's all the horrors of converting between strings &
> numbers. SQL Server understands the difference between Null and Zero, so I
> would have thought that OneWorld could as well.
>
> Is there a simpler way?
>
> Cheers...
>
> ... Alan =8^)
> __________________________________
> Alan Watt
> Jade Enterprise Solutions Ltd.
> "Making Good Ideas Happen"
> __________________________________
> Tel/Fax: +44 (0)161 428 1288
> Mobile: +44 (0)7970 255073
> Email: [email protected]
> URL: http://www.jade.tm
> __________________________________
>
>
>
>
>
> --------------------------
> To view this thread, visit the JDEList forum at:
> http://198.144.193.139/cgi-bin/wwwthreads/showflat.pl?Cat=0&Board=OWDEV&Nu
> mber=2975
> *************************************************************
> This is the JDEList One World / XE Developers Mailing List.
> Archives and information on how to SUBSCRIBE, and
> UNSUBSCRIBE can be found at http://www.JDELIST.com
> *************************************************************
>
 
Back
Top