Subject | Re: [IBO] null result from a query |
---|---|
Author | Helen Borrie (TeamIBO) |
Post date | 2002-03-09T11:12:15Z |
At 11:39 AM 09-03-02 +0100, you wrote:
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
>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