Subject Re: [IBO] null result from a query
Author Helen Borrie (TeamIBO)
At 11:39 AM 09-03-02 +0100, you wrote:
>how do I detect that a query - done with TIBOQuery - gave null result ?

If it is a buffered dataset, test the IsEmpty property:
MyQuery.Open;
If MyQuery.IsEmpty then
ShowMessage('Query is empty');

For any dataset (buffered or not) you can use
MyQuery.Open;
If (MyQuery.BOF and MyQuery.EOF) then
ShowMessage('Query is empty');


regards,
Helen Borrie (TeamIBO Support)

** Please don't email your support questions privately **
Ask on the list and everyone benefits
Don't forget the IB Objects online FAQ - link from any page at
www.ibobjects.com