>Open your source query and start to loop through it, after this style:
>
>begin
>....
>if not mydsql.prepared then mydsql.prepare;
>
>with myquery do
>begin
> First;
> while not eof do
> begin
> mydsql.params[0].AsWhatever := FieldByName('whatever').AsWhatever;
> mydsql.params[1].AsSomething := FieldByName('sthg').AsSomething;
> // and so on until all the dsql params have their values
> mydsql.execute;
> Next;
> end;
>end;
>ibotransaction1.commit;

Ok, now if I have a very large source dataset, I want to commit every
15,000 records or so, right? So, I would put a counter in the loop and do
commits periodically in the loop as well.

If I commit in the middle, do I have to re-start my transaction? Or, would
this be a good place for CommitRetaining?

-Joe