At 06:35 AM 27/04/2006, you wrote:

>I know that the prepared property should be used whenever I'll be
>using paramByName.

Not needed when using ParamByName - that method will call Prepare
itself. It *is* necessary to check Prepared when referring to the
Params[] property.

>Do I need to set "Prepared" more than once?

It doesn't hurt if you do, but the best way is to *check* and call it
if needed:

if not MyDataset.Prepared then
MyDataset.Prepare;

>Can I just set parameters and have the result change without calling close
>and open?

Certainly - that's what parameters are for!

>What about DML queries like Inserts that use ExecSQL?

No different from datasets in this respect.

Helen