extracting params from stored procedure

[rlilov]

Hello
Using ADO i am able to get the list of params of selected Stored procedure
and put them in inmemory metadataset with foll code

Var storedProcMeta:TAdoStoredProc;
begin
StoredProcMeta.ProcedureName := '"'+spname+'"';
with StoredProcMeta do begin
for i:=0 to MetaDataSet.FieldCount-1 do
Parameters.refresh;
for i := 0 to Parameters.Count - 1 do begin
MetaDataSet.Append;
MetaDataSet.FieldByName('ColumnName').AsString:=Parameters.Name;
MetaDataSet.FieldByName('ColumnType').AsInteger:=ord(DataTypeToVCLDataType(ord(Parameters.Datatype)));
MetaDataSet.FieldByName('ParamType').AsInteger:=ord(Parameters.Direction);
MetaDataSet.Post;


I will appreciate some advise as to how i can do that with SDAC

Thnaks in advance
Rumen

[Guest]

You can use similar methods of TMSStoredProc or use TMSMetadata.