Subject Re: [IBO] SQL Error code = -804
Author Svein Erling Tysvær
Hi boss, hope you're enjoying your holiday!

I had problems with Open a long time ago, and switched to calling First. I think it was that Eof occationally was true
even though the dataset contained records, but it may have been the other way around. I never checked very carefully (e.g.
maybe I forgot to call Close between repetitions?) since the fix was so simple.

Svein Erling

Aage Johansen wrote:

> Jason Wharton wrote:
> >
> > If you are using a buffered query then IsEmpty is the best. This is because
> > it pertains to the buffer containing any records or is it empty.
> >
> > If you are using a unidirectional dataset then call the First method (and
> > not Open) and check for Eof.
> >
>
> Is it just 'the best' methods, or are these the one and only safe way?
> Is it this way for both IBO/3 and IBO/4?
> I have - for a long time - used Open and then tested for Eof. I haven't
> noticed any problems with this, but maybe I should straighten up the
> code?
>
> Regards,
> Aage J.