The isnull function returns a value of type boolean, which indicates whether the parameter passed to it is null. If the parameter is null then the value true is returned, and if the parameter is not null then the value false is returned. This function is usually used to test values retrieved from databases with recordset.field.
The isnull function's only parameter is an expression of variant type.
The following code fragment uses isnull to check the values of the last_name and first_name fields to see if they are null, and if so handle them specially.
new(rs);
rs.open(conn, 'select last_name, first_name from customer', rsforward);
while not rs.eof
begin
if isnull(rs.field('last_name')) then
write('NULL')
else
write(rs.field('last_name'));
write(', ');
if isnull(rs.field('first_name')) then
writeln('NULL')
else
writeln(rs.field('first_name'))
rs.movenext;
end;
rs.close;
dispose(rs);
Operating Systems: All
Standard Pascal: No