FRequireEmptyStrToNull

[cis-wurzen]

Any reason for not setting FRequireEmptyStrToNull to True in TVirtualTable?

Converted some TTable (Paradox) to TVirtualTable.

Code: Select all

  TFieldXXX.AsString := '';
  if TFieldXXX.IsNull then
    ShowMessage('Empty')
  else
    ShowMessage('Filled');

Paradox-Field shows "Empty", VirtualTable shows "Filled".

[AlexP]

Hello,

Such behaviour of VirtualTable is due to the fact that many DBs make out empty string '' and NULL, this is made for compatibility with all DBS. We will review the opportunity to add the SetEmptyStrToNull option for VirtualTable in one of the next versions.