still having problems with global functions and NULL values
Hi there,
I'm using Delphi6 + RB 7.03
I have many db fields and in their OnGetText event, I'm calling 3 or 4
functions (I don't want to repeat the same code in all OnGetText
events).
This is working great but when encountering a NULL value, the following
dbFields are not correctly displayed anymore and take the same value
that the one from the NULL valued field.
example with no null value :
original content modified by function content
field1 A A1
field2 B B1
field3 C C1
filed4 D D1
example null value (field2) :
original content modified by function content
field1 A A1
field2 NULL B1
field3 C B1
filed4 D B1
thanks for your help, this bug is driving me sin ...
Best Regards,
Etienne
I'm using Delphi6 + RB 7.03
I have many db fields and in their OnGetText event, I'm calling 3 or 4
functions (I don't want to repeat the same code in all OnGetText
events).
This is working great but when encountering a NULL value, the following
dbFields are not correctly displayed anymore and take the same value
that the one from the NULL valued field.
example with no null value :
original content modified by function content
field1 A A1
field2 B B1
field3 C C1
filed4 D D1
example null value (field2) :
original content modified by function content
field1 A A1
field2 NULL B1
field3 C B1
filed4 D B1
thanks for your help, this bug is driving me sin ...
Best Regards,
Etienne
This discussion has been closed.
Comments
I'm unclear about what you would like to happen in there is a Null value in
Field2. If Field2 is Null, would you still like it to print "B", or would
you like it to be empty. You mention you are calling 3 or 4 routines inside
the OnGetText event. Perhaps you could check for a null value in one of
these methods and format the output accordingly.
--
Nico Cizik
Digital Metaphors
http://www.digital-metaphors.com
if you have a NULL value, the following values are stuck to the one
preceding the null value.
Even for "non null" values, the results of the functions are not correct
anymore ....
That's really strange ...
In article <40eeaaea$1@dm500.>, support@digital-metaphors.com says...
Ok, so when a Null value is encountered, the previous value is reprinted.
This is not a know behavior of ReportBuilder. Be sure none of your event
handler code is causing this. If possible, please send a small example
demonstrating this behavior to support@digital-metaphors.com and I'll take a
look at it for you.
--
Nico Cizik
Digital Metaphors
http://www.digital-metaphors.com