| Subject | Re: [IBO] Prepared |
|---|---|
| Author | Helen Borrie |
| Post date | 2006-04-26T22:03:33Z |
At 06:35 AM 27/04/2006, you wrote:
itself. It *is* necessary to check Prepared when referring to the
Params[] property.
if needed:
if not MyDataset.Prepared then
MyDataset.Prepare;
Helen
>I know that the prepared property should be used whenever I'll beNot needed when using ParamByName - that method will call Prepare
>using paramByName.
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 closeCertainly - that's what parameters are for!
>and open?
>What about DML queries like Inserts that use ExecSQL?No different from datasets in this respect.
Helen