Geoff:

> Note: For simplicity I have shown ParamByName and FieldByName
> above. These are acceptable for simple situations but keep in
> mind that for looping situations (eg importing many records)
> it is better to keep track of the column references and use
> them directly.

Hi!

isn't it so that as soon as any SQL execution is done within the loop, that
these ByName functions become irrelevant in terms of performance? I mean a
SQL Post, for example, will probably take as long as thousands of
FieldByName's, isn't that so?

Cheers,
Tobias