Problem in Joining two pipelines (Master - Detail)
I am using D6 ent, RB 6.03 ent.
I have a report that has two pipelines (master and detail, for the sake of
this message). The master pipeline has a float field (call it util), and is
sorted decending by that field. The field util may be null. The deatil
pipeline is also sorted by util, and the two pipelines are joined using the
masterPipeline property and the MasterFieldLinks property.
The problem is that I get at time an 'Invalid Variant Operation' Exception.
It seems that the exception happens only when the pipelines have records
where util is not null, and also records where util is null. The problem is
that when comparing the values of the two pipelines, RB gets to compare a
null value with a not null value.
The source of the problem is in the ppDB unit, line 3621, where a comparison
is done - lDetailFieldValue > lMasterFieldValue.
I see this as a problem becouse RB should be doing one of the following
things:
1. Define how to compare null with a not null value, and do so. Note that
DBs consider null as a lesser value then all other non null values.
2. Raise an exception that states excactly what is the problem - tring to
connect two pipelines, where one of the linked fields is null and the other
is not.
RB should not allow the 'Invalid Variant Operation' message to appear, as it
does not give the information of what is the problem, and you (or I) need
some long time of debugging in order to find what is wrong.
If you have a fix for the problem, I'll be happy to get one.
If you need help solving the problem, you have my email.
--
Yoav Abrahami
R&D Software Engineer
T-Soft - The Essence of Network Knowledge
---------------------------------------------------------------------
Tel: +972 (0)9-971-3148 (Direct)
Tel: +972-(0)9-971-3131 (Main)
Fax: +972-(0)9-971-3133
E-mail: yoav@tsoft-tele.com
www.tsoft-tele.com
I have a report that has two pipelines (master and detail, for the sake of
this message). The master pipeline has a float field (call it util), and is
sorted decending by that field. The field util may be null. The deatil
pipeline is also sorted by util, and the two pipelines are joined using the
masterPipeline property and the MasterFieldLinks property.
The problem is that I get at time an 'Invalid Variant Operation' Exception.
It seems that the exception happens only when the pipelines have records
where util is not null, and also records where util is null. The problem is
that when comparing the values of the two pipelines, RB gets to compare a
null value with a not null value.
The source of the problem is in the ppDB unit, line 3621, where a comparison
is done - lDetailFieldValue > lMasterFieldValue.
I see this as a problem becouse RB should be doing one of the following
things:
1. Define how to compare null with a not null value, and do so. Note that
DBs consider null as a lesser value then all other non null values.
2. Raise an exception that states excactly what is the problem - tring to
connect two pipelines, where one of the linked fields is null and the other
is not.
RB should not allow the 'Invalid Variant Operation' message to appear, as it
does not give the information of what is the problem, and you (or I) need
some long time of debugging in order to find what is wrong.
If you have a fix for the problem, I'll be happy to get one.
If you need help solving the problem, you have my email.
--
Yoav Abrahami
R&D Software Engineer
T-Soft - The Essence of Network Knowledge
---------------------------------------------------------------------
Tel: +972 (0)9-971-3148 (Direct)
Tel: +972-(0)9-971-3131 (Main)
Fax: +972-(0)9-971-3133
E-mail: yoav@tsoft-tele.com
www.tsoft-tele.com
This discussion has been closed.
Comments
exception in this case. This has been fixed in RB 7. Order from our website
www.digital-metaphors.com or contact info@digital-metaphors.com for your
specific upgrade information.
Cheers,
Jim Bennett
Digital Metaphors
http://www.digital-metaphors.com
info@digital-metaphors.com