Can a parameter safely be removed from a Delphi TADOCommand at runtime.

Question

My Delphi 2006 TADOCommand has it's

    CommandText (including parameters),  
    Prepared (True),  
    ParamCheck (True)

properties all set at design time.

Is there a way for me to go about deleting some of it's Parameters at run time, without having to change the CommandText to accomodate these changes. This is desireable in the case that some of the table columns that the parameters reference do not need updating/inserting.

I'm thinking of something along the lines of

TADOCommand.Parameters.ParamByName('MyParam').SafelyRemove;

Many Thanks,
Duncan

Answer 1

Each item in Parameters collection corresponds to parameter marker in the command text. It is like API to this marker. Removing items from Parameters will not remove the corresponding marker. If you does not need to touch some field in your command text, then you have to modify command text and remove corresponding parameter marker.

When command text is prepared, the DBMS has built command execution plan and allocated some resources, required for command execution. If you will change the command text, then DBMS has to build new command execution plan.

Kind of that ...

Answer 2

Because parameters placeholders (:PARAMn) are embedded in the SQL text, I don't see how you can add or remove parameters without changing CommandText. You would have a mismatch.

Answer 3

In case when the command text is dynamic-updateble i usually working with params like this: *Parameters.Clear; Parameters.ParseSQL(ADOCommand.CommandText, true); * it will automatically create parameter list with correct parameters names.