> >
> > 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?

Thanks

Tim


[Non-text portions of this message have been removed]