如何判断sql库中image型字段为空

[haoqingqlm]

用.isnull不行

[firetoucher]

sql语句：
where field is not null

[DWGZ]

sql 语句用 IsEmpty
Delphi 用 IsNull

[haoqingqlm]

字段类型是image以上方法试了不行

[jpyc]

关注

[不停歇的步伐]

if FindField('').value = null

[dudunono]

IsBlob
或者SaveToFile ，SaveToStream

[laome]

var
B:TBlobStream;
MJpg:TJpegImage;
begin
B:=TBlobStream.create(query1.FieldbyName('Blobfield') as TBlobfield,bmRead);
MJpg:=TJpegImage.create;
try
if B.size>0 then begin
MJpg.LoadFromStream(B);
Image1.Picture.assign(MJpg);
end;
finally
B.Free;
MJpg.Free;
end;
end;
end;

[susanxjuan]

if not (query1.FieldByName('字段') as TBlobField).IsNull then begin


end;