• Introducing Dark Mode! Switch by clicking on the lightbulb icon next to Search or by clicking on Default style at the bottom left of the page!

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: alan.watt@jade.tm
URL: http://www.jade.tm
__________________________________
 

Gergely_Pongracz

Well Known Member
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:alan.watt@jade.tm]
> Reply To: jdeowdev@jdelist.com
> Sent: Wednesday, December 20, 2000 3:38 PM
> To: jdeowdevml@jdelist.com
> 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: alan.watt@jade.tm
> 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
> *************************************************************
>
 
Top