A lookup buffer cannot distinguish a NULL value from a "zero" value
Source position: mselookupbuffer.pas line 250
public function tcustomlookupbuffer.lookuptext( |
const integerkeyfieldno: Integer; |
const textfieldno: Integer; |
const keyvalue: Integer; |
const adefault: msestring = '' |
):msestring; overload; |
const int64keyfieldno: Integer; |
const textfieldno: Integer; |
const keyvalue: Int64; |
const adefault: msestring = '' |
):msestring; overload; |
const stringkeyfieldno: Integer; |
const textfieldno: Integer; |
const keyvalue: msestring; |
const adefault: msestring = '' |
):msestring; overload; |
A lookup buffer cannot distinguish a NULL value from a "zero" value: lookuptext returns '0' for a NULL integer field, and '' for a NULL text, float or datetime field — the same as it would for an actual 0 or empty string.