>I tried only preparing once but got an exception - I had to close and
>re-open (via Prepare)

Well, try using open and close for your cursor rather than execute. Then
you should have no problem with only preparing once (there is a bug which I
thought only affected DSQLs, but maybe it is all calls to Execute).

>I also wrote I was gathering data for an in-memory structure - I'm only
>collecting data, not updating records.

Sorry, I didn't notice - I guess the C-code demanded too much of my
attention (I'm 100% Delphi).

Set