FirebirdSQL NaN value for numeric field

[msd 5]

Hello,

 

FirebirdSQL has a replacement in Delphi for the null value, and it is called NaN (non-numeric value).

I can't prevent this situation, ID DB, so I need to check if my variable (Real type) and my DataSet field (TFloat type) are numeric or not (nil, null, nan, etc.).

 

Thanks in advance...

[PeterBelow 238]

14 minutes ago, msd said:

Hello,

 

FirebirdSQL has a replacement in Delphi for the null value, and it is called NaN (non-numeric value).

I can't prevent this situation, ID DB, so I need to check if my variable (Real type) and my DataSet field (TFloat type) are numeric or not (nil, null, nan, etc.).

 

Thanks in advance...

TField.IsNull is the way to check if a database field is NULL. Do not rely on this conditions beeing mapped to a specific value.