How to check for null value

chuckchuck
edited 12:25AM in FastReport 4.0
I want to do something like this in Fast Script:

IF <frxdata."MyValue"> is not null then
... do something ..
END

How can I do this? Thanks for any help.

Comments

  • gordkgordk St.Catherines On. Canada.
    edited 12:25AM
    first to check for nulls the report engine setting convert nulls must be set to false.
    when convertnulls is true default
    the other option is to check for empty string or 0 for numeric fields.
  • Anu de DeusAnu de Deus Hampshire, UK
    edited 12:25AM
    gordk wrote: »
    the other option is to check for empty string or 0 for numeric fields.

    Sorry Gordon, but that is not an (inteligent) option in any language or script in the world!
  • Luis Miguel MolineroLuis Miguel Molinero
    edited 12:25AM
    I agree it's not an (intelligent) option.
    Anyway I set convert nulls to false in the engine and the code (Pascal)

    if (<DataSetName."FieldNambe"> = Null) then
    begin
    end;

    doesn't work, it doesn't detect the null values

    Any suggestion will be wellcome
  • Luis Miguel MolineroLuis Miguel Molinero
    edited 12:25AM
    Well, I found the solution: I must assign false to convertnulls option of the engine after loaded the report.

Leave a Comment

Rich Text Editor. To edit a paragraph's style, hit tab to get to the paragraph menu. From there you will be able to pick one style. Nothing defaults to paragraph. An inline formatting menu will show up when you select text. Hit tab to get into that menu. Some elements, such as rich link embeds, images, loading indicators, and error messages may get inserted into the editor. You may navigate to these using the arrow keys inside of the editor and delete them with the delete or backspace key.

Home • FastReport 4.0Comment As ...

© Vanilla Keystone Theme 2024