Merging two dataset

I have one "big" TOracleDataSet which I can't change 'cause it's using in many different parts of huge project. I want to add just one record to this dataset for using in another grid. The solve way I see it is create another one oracle data set which will combine wanted record an开发者_JAVA百科d another ones from "big" dataset. In other words, "small" dataset includes "big" dataset.

Try this maybe?

TxQuery Project

This was a commercial project at one time, but the auther was convinced to release it opensource.

TxQuery component is a TDataSet descendant component that can be used to query one or more TDataSet descendant components using SQL statements. It is implemented in Delphi 100% source code, no DLL required, because it implements its own SQL syntax parser and SQL engine.

That quote was taken from the page of the current maintainer, I believe, Chau Chee Yang .

Either this or maybe TClientDataset might be your best options.