How to return the specific data result set
How to return the specific data result set
Stored procedure returns 3 dataset. How to handle in TMSStoredProc? And could it return specific dataset in DBGrid? I'm using SDAC 9.2.4 and XE2
Re: How to return the specific data result set
You can skeep unused datasets by calling the OpenNext method method the respective number of times.
See our documentation for more information on opening subsequent datasets:
https://www.devart.com/sdac/docs/devart ... next().htm
See our documentation for more information on opening subsequent datasets:
https://www.devart.com/sdac/docs/devart ... next().htm
Re: How to return the specific data result set
Thanks. I tested your suggestion. But how to using single TMSStoredProc to show different dataset into different DBGrid?
Re: How to return the specific data result set
TMSStoredProc can display only one dataset at a time. If you need to open multiple datasets simultaneously, you may try using the OpenDatasets method of TMSConnection, for example:
MSQuery1.SQL.Text := 'SELECT * FROM Dept';
MSQuery2.SQL.Text := 'SELECT * FROM Emp';
MSConnection1.OpenDatasets([MSQuery1, MSQuery2]);
See this page for more information on opening multiple datasets simultenously
https://www.devart.com/sdac/docs/devart ... set[]).htm
MSQuery1.SQL.Text := 'SELECT * FROM Dept';
MSQuery2.SQL.Text := 'SELECT * FROM Emp';
MSConnection1.OpenDatasets([MSQuery1, MSQuery2]);
See this page for more information on opening multiple datasets simultenously
https://www.devart.com/sdac/docs/devart ... set[]).htm