How to clear a table type parameter
Posted: Wed 20 Jan 2016 15:55
Hello,
when using table type parameters how can they be cleared?
Parameter assignment as in the help file is used:
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.
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.