At 12:59 PM 30/06/2003 +0200, you wrote:

> > >
> > > ParamByName('BATCHNUM').AsInteger := Batch;
> > > ParamByName('TERMID').AsString := TermID;
> > >
> > > if not Active then Open else Refresh;
> >
> > Not this line. Nothing will happen here if the dataset happens to
> >be Active.
>
>So then I should close the dataset between queries? What I mean is that I
>thought that this was the whole point of refresh - that you didn't have to
>close the dataset, and that it would fetch only the new rows?

Hmmm, look at the logic of your statement and think about it again...

Helen