Ergebnis der Suchanfrage

• Forum: Programmieren allgemein

  AW: Mysql Typs (Null) Typ (Integer)

   
    by sx2008, 25. Aug 2013
  If you want to transfer a Value that could be both a integer or NULL you have to use the data type "Variant".
  A Variant can contain different data type like integer, floats, booleans, strings.
  And a Variant can also be Null!
  This means that Variant is a nullable data type.
  To get or set the value of a field you can use the property Value.
  The Properties AsString, AsInteger, AsBoolean,... are...
• Forum: Programmieren allgemein

  AW: Mysql Typs (Null) Typ (Integer)

   
    by sx2008, 25. Aug 2013
  // Fill a parameter with NULL
  QueryB.ParamByName('NewID').Value := Null;
  
  // Fill a field with NULL
  QueryB := Null;
  // alternative way to set a field to NULL
  QueryB.FieldByName('SomeField').Clear;
  
  // testing if a field is NULL
  if Query.FieldByName('SomeField').IsNull then ...