Subject Re: [IBO] When have a query it's data
Author Helen Borrie
Guido,
It seems you don't have any data. First() will be at both BOF and EOF if
the dataset is empty.

Try this:

At 02:48 AM 02-01-01 +0100, you wrote:
>I have a query FMQuery and in the AfterOpen-Event I want to go through
>the data, but no data is there. It's look like:
>procedure TCustomersDataModule.FMQueryAfterOpen(IB_Dataset:
>TIB_Dataset);
>begin

if FMQuery.IsEmpty then
showmessage('Empty dataset')
else
begin

> FMQuery.First;
> while not FMQuery.EOF do
> begin
> showmessage('blabla');
> FMQuery.Next;
> end;

end;

>end;

If you discover the dataset is empty, it means either there IS no data to
match your SQL or that the Open didn't work.

If the Open didn't work, look to see whether the transaction is either
uncommitted, or not restarted; or whether perhaps the statement is not
receiving the parameter you expect.

H.

All for Open and Open for All
InterBase Developer Initiative ยท http://www.interbase2000.org
_______________________________________________________