Page 1 of 1
Forum

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!



Share:
Notifications
Clear all

Lazarus Pascal - Databases - How to check FieldByName value to be NULL

1 Posts
1 Users
0 Likes
2,071 Views
 Hans
(@hans)
Famed Member Admin
Joined: 9 years ago
Posts: 2235
Topic starter  

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.


ReplyQuote
Share: