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
__________________________________
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
__________________________________