close Warning: Can't synchronize with repository "(default)" (/var/svn/tolp does not appear to be a Subversion repository.). Look in the Trac log for more information.

Opened 21 years ago

Closed 21 years ago

#163 closed defect (fixed)

Error in values "null" in the functions of access to Base of data

Reported by: rcsoto Owned by: manuelb
Priority: normal Milestone:
Component: DataBase Version: head
Severity: normal Keywords:
Cc:

Description

Hi.

When executing a query in Data Base, that it contains values "null", in some of its
columns, the null value is replaced by zero "0".

Example (in SqlServer):

Text TxtSQL = "select cast(null as float) as myCol";
Set SetSQL = DBTable(SetSQL);

Real MyValue = SetSQL[1][1];
MyValue = 0;

Thanks

Change History (2)

comment:1 Changed 21 years ago by manuelb

Priority: high → normal
Severity: critical → normal
Status: new → assigned

comment:2 Changed 21 years ago by manuelb

Resolution: → fixed
Status: assigned → closed

This problem was to be solved in the future, but thanks to this bug it is ok now!

It is impossible to use dynamic libs and getting real values that can be NULL.
Therefore, a new internal function has been created: DBCheckNull.

It checks whether a Real value was really the value returned or NULL. Of course,
not every value is checked, because a small delay in every Real value in every row
would end up as a horrible access time, so a couple of tweaking has been done to
speed thinks up and still have 100% reliability.

A fix for this is on testing phase and should be on the cvs soon.

Also, a new test has been created and will be up too.

Note: See TracTickets for help on using tickets.