FireDAC.Stan.Option.TFDFormatOptions.StrsEmpty2Null

From RAD Studio API Documentation
Jump to: navigation, search

Delphi

property StrsEmpty2Null: Boolean read GetStrsEmpty2Null write SetStrsEmpty2Null

C++

__property bool StrsEmpty2Null = {read=GetStrsEmpty2Null, write=SetStrsEmpty2Null, stored=IsSE2NS, default=0};

Properties

Type Visibility Source Unit Parent
property published
FireDAC.Stan.Option.pas
FireDAC.Stan.Option.hpp
FireDAC.Stan.Option TFDFormatOptions

Description

Controls the conversion of zero-length string values to NULL value.

Use the StrsEmpty2Null property to control whether FireDAC should convert string values with zero length to NULL value (True) or not (False). The default value is False

The property applies to column values at rows fetching and to parameter values at command execution. The property will be applied after StrsTrim is applied.

When an application is executing a query:   

FDQuery1.SQL.Text := 'SELECT * FROM MyTab WHERE fld = :p';
FDQuery1.Params[0].AsString := ;
FDQuery1.Open;

  And the query returns no records, although MyTab has some records with an empty string in the FLD field, then you have to set StrsEmpty2Null to False to get those records.

See Also