Re: DB null value returned by TDataSet's FieldValues

You can use FieldByName('SomeField').IsNull or you can assign the Value
property to a variant and test the variant.

V := Qry.FieldByName('SomeField').Value

where V is of type Variant. Then you can use

if VarIsNull(V) then...

--
Bill Todd (TeamB)
.

Relevant Pages

  • Re: Invalid Use of Null Error
    ... Make your variables of type Variant. ... Nulls and empty strings, because Variants are less efficient to process. ... > i am trying to get data from a record set. ...
    (microsoft.public.access.formscoding)
  • Re: Text as argument to Randomize function
    ... the Randomize function. ... The VBA Help says that the argument is of type Variant, ... understand it - includes strings. ...
    (microsoft.public.vb.general.discussion)
  • Re: Getting all classes in a package
    ... you can automatically get a list with a variant of ... Canadian Mind Products, Roedy Green. ... http://mindprod.com Again taking new Java programming contracts. ... Prev by Date: ...
    (comp.lang.java.help)
  • Re: Default method arguments
    ... > 2) I don't whant only to _print_ x. ... > def f ... > So I think is the best variant, ... Prev by Date: ...
    (comp.lang.python)
  • Re: Is anything spectacular going to happen around Delphi anymore?
    ... Joanna Carter (TeamB) wrote: ... > so it still could not be stillborn. ... until some time along the road that Borland decided that the Win32 ... variant would not appear. ...
    (borland.public.delphi.non-technical)