Dear all,
we are running dbforms 1.1.3. One of our dbforms has a couple of
textfields for displaying floating point values e.g. defined as
<field name="MEAN" fieldType="float" size="15"/>
in dbforms-config.xml.
These fields display 0.0 whenever the database returns a NULL value. Now
suppose that two such textfields (A and B) contain the following values:
A: 0.0 (database contains NULL) B: 0.0 (database contains NULL)
Suppose, the user changes the value for B yielding:
A: 0.0 B: 1.2
and then clicks the updateButton associated with the dbform, the result
will be the following:
A: 0.0 (database contains 0.0!!!!) B: 1.2 (database contains 1.2)
^^^^^^^^^^^^^^^^^^^^^^^^^^
Thus all NULL fields of a record are changed to 0.0 by an update
operation. However, in our database the value 0.0 represents a valid
measurement which is taken into account within subsequent calculations
while the value NULL is not taken into within those calculations.
To avoid the problem we tried to declare the database fields as varchar2
instead of float in order to avoid the 0.0 representation for NULL values.
However, this trick only works when writing integer values into the
database. An attempt to enter a floating point number into such a
textfield results in a database "illegal number format" error for some
reasons.
Now my questions are:
Is there a possibility with dbforms 1.1.3 to have NULL values of
textfields for float data shown as empty strings instead as 0.0?
Is it possible to use the format attribute of the db:textfield tag
(current dbforms version) to have a possibility NULL values of textfields
for float data shown as empty strings instead as 0.0?
Best regards
-Michael Stadler-
-------------------------------------------------------
This SF.Net email is sponsored by: Oracle 10g
Get certified on the hottest thing ever to hit the market... Oracle 10g.
Take an Oracle 10g class now, and we'll give you the exam FREE.
http://ads.osdn.com/?ad_id=3149&alloc_id=8166&op=click
_______________________________________________
DbForms Mailing List
http://www.wap-force.net/dbforms
