Home General
New Blog Posts: Merging Reports - Part 1 and Part 2

still having problems with global functions and NULL values

edited July 2004 in General
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

Comments

  • edited July 2004
    Hi Etienne,

    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.

    --
    Best Regards,

    Nico Cizik
    Digital Metaphors
    http://www.digital-metaphors.com
  • edited July 2004
    here, clearly, there is a non correct behaviour.

    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...
  • edited July 2004
    Hello,

    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.

    --
    Best Regards,

    Nico Cizik
    Digital Metaphors
    http://www.digital-metaphors.com
This discussion has been closed.