Welcome to the Tweaking4All community forums!
When participating, please keep the Forum Rules in mind!
Topics for particular software or systems: Start your topic link with the name of the application or system.
For example “MacOS X – Your question“, or “MS Word – Your Tip or Trick“.
Please note that switching to another language when reading a post will not bring you to the same post, in Dutch, as there is no translation for that post!
Ad Blocking Detected
Please consider disabling your ad blocker for our website.
We rely on these ads to be able to run our website.
You can of course support us in other ways (see Support Us).
Lazarus Pascal - Databases - How to check FieldByName value to be NULL
Delphi, Lazarus, Free Pascal
(@hans)
Famed Member Admin
Joined: 10 years ago
Posts: 2457
Topic starter
January 27, 2021 6:10 AM
Usually we read the values of our TQuery results with the TQuery.FieldByName('fieldname').AsInteger (AsString, AsBoolean, etc).
What is the easiest way to check if a value if NULL?
Little trick to test if a field value of your TQuery is NULL or not;
MyQuery.FieldByName('field1').IsNull
This returns a Boolean.
Ad Blocking Detected
Please consider disabling your ad blocker for our website.
We rely on these ads to be able to run our website.
You can of course support us in other ways (see Support Us).
