| Components | All | New | MacOS | Windows | Linux | iOS | ||||
| Examples | Mac & Win | Server | Client | Guides | Statistic | FMM | Blog | Deprecated | Old | |
FM.NULL
Returns a null value.
| Component | Version | macOS | Windows | Linux | Server | iOS SDK |
| FM FMSQL | 5.1 | ✅ Yes | ✅ Yes | ✅ Yes | ✅ Yes | ✅ Yes |
MBS( "FM.NULL" )
Parameters
none
Result
Returns empty container.
Description
Returns a null value.FileMaker doesn't really have a NULL value, but other databases make a difference between empty text ("") and no value (NULL).
This function returns a special container value with no content.
SQL.SetParamValue and SQL.SetParamValues can use this value to pass NULL to the database.
Examples
get null value:
MBS("FM.NULL")
See also
Blog Entries
This function is free to use.
Created 20th April 2015, last changed 14th September 2015
