when using table type parameters how can they be cleared?
Parameter assignment as in the help file is used:
However, the TMSTableData object is not only closed but destroyed after the stored procedure is executed. This leaves a reference in TMSParam object, which will cause an access violation when stored procedure is prepared the next time.MSStoredProc.ParamByName('TVP').AsTable := MSTableData.Table;
Calling Clear procedure of TMSParam did not completely reset the parameter, neither did assigning nil to AsTable property work.
SDAC version is 7.1.3 for RAD Studio 7.