Page 1 of 1

FRequireEmptyStrToNull

Posted: Wed 19 Sep 2012 13:00
by 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".

Re: FRequireEmptyStrToNull

Posted: Thu 20 Sep 2012 10:48
by 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.