<div>
You can just cast the OleVariant back to the original type when assigning it at the Client side.
</div>


<div>
1) What Server / Client side are you referring to ?<br />
2) What do you mean by export an TADOQuery to an OleVariant ?<br />
3) What do you mean by loading the OleVariant back to another dataset ?<br />
4) Then, that is maybe redundancy with 1st question, how does that OleVariant get transfered from *server* to *client* ?<br />
<br />
JimyX, do you care explaining a bit more, with a code sample ? I'm sorry , but if I couldn't see it, I would not believe that your answer can be as cryptic as the question. Yet it is and you are a Sage... Or am I missing something so implicitly evident there ?
</div>


<div>
hi, <br />
<br />
please check this samples &amp;&nbsp;some useful links for u..<br />
<br />
<a href="http://www.scalabium.com/faq/dct0063.htm" rel="ugc">http://www.scalabium.com/faq/dct0063.htm</a><br />
<a href="http://delphi.icm.edu.pl/ftp/d30free/axshell.htm" rel="ugc">http://delphi.icm.edu.pl/ftp/d30free/axshell.htm</a><br />
<a href="http://edn.embarcadero.com/article/22571" rel="ugc">http://edn.embarcadero.com/article/22571</a><br />
<a href="http://www.podgoretsky.com/ftp/docs/Delphi/D5/dg/5_ds3.html" rel="ugc">http://www.podgoretsky.com/ftp/docs/Delphi/D5/dg/5_ds3.html</a><br />
<a href="http://stackoverflow.com/questions/378737/is-there-some-better-way-to-copy-all-dataset-fields-and-their-properties-to-anoth" rel="ugc">http://stackoverflow.com/questions/378737/is-there-some-better-way-to-copy-all-dataset-fields-and-their-properties-to-anoth</a><br />
<br />
by<br />
kumaresan.v<br />
<br />
<br />
<a href="https://filedb.experts-exchange.com/incoming/2011/05_w21/459711/Unit1.pas" target="_blank" class="file-inline" title="PAS file (2 KB)"><svg xmlns="http://www.w3.org/2000/svg" viewBox="0 0 512 512"><path d="M67.508 468.467c-58.005-58.013-58.016-151.92 0-209.943l225.011-225.04c44.643-44.645 117.279-44.645 161.92 0 44.743 44.749 44.753 117.186 0 161.944l-189.465 189.49c-31.41 31.413-82.518 31.412-113.926.001-31.479-31.482-31.49-82.453 0-113.944L311.51 110.491c4.687-4.687 12.286-4.687 16.972 0l16.967 16.971c4.685 4.686 4.685 12.283 0 16.969L184.983 304.917c-12.724 12.724-12.73 33.328 0 46.058 12.696 12.697 33.356 12.699 46.054-.001l189.465-189.489c25.987-25.989 25.994-68.06.001-94.056-25.931-25.934-68.119-25.932-94.049 0l-225.01 225.039c-39.249 39.252-39.258 102.795-.001 142.057 39.285 39.29 102.885 39.287 142.162-.028A739446.174 739446.174 0 0 1 439.497 238.49c4.686-4.687 12.282-4.684 16.969.004l16.967 16.971c4.685 4.686 4.689 12.279.004 16.965a755654.128 755654.128 0 0 0-195.881 195.996c-58.034 58.092-152.004 58.093-210.048.041z"/></svg>Unit1.pas</a><br />
<a href="https://filedb.experts-exchange.com/incoming/2011/05_w21/459712/Unit1.dfm" target="_blank" class="file-inline" title="form  (1 KB)"><svg xmlns="http://www.w3.org/2000/svg" viewBox="0 0 512 512"><path d="M67.508 468.467c-58.005-58.013-58.016-151.92 0-209.943l225.011-225.04c44.643-44.645 117.279-44.645 161.92 0 44.743 44.749 44.753 117.186 0 161.944l-189.465 189.49c-31.41 31.413-82.518 31.412-113.926.001-31.479-31.482-31.49-82.453 0-113.944L311.51 110.491c4.687-4.687 12.286-4.687 16.972 0l16.967 16.971c4.685 4.686 4.685 12.283 0 16.969L184.983 304.917c-12.724 12.724-12.73 33.328 0 46.058 12.696 12.697 33.356 12.699 46.054-.001l189.465-189.489c25.987-25.989 25.994-68.06.001-94.056-25.931-25.934-68.119-25.932-94.049 0l-225.01 225.039c-39.249 39.252-39.258 102.795-.001 142.057 39.285 39.29 102.885 39.287 142.162-.028A739446.174 739446.174 0 0 1 439.497 238.49c4.686-4.687 12.282-4.684 16.969.004l16.967 16.971c4.685 4.686 4.689 12.279.004 16.965a755654.128 755654.128 0 0 0-195.881 195.996c-58.034 58.092-152.004 58.093-210.048.041z"/></svg>Unit1.dfm</a><br />
<a href="https://filedb.experts-exchange.com/incoming/2011/05_w21/459713/Project1.exe" target="_blank" class="file-inline" title="execution file (913 KB)"><svg xmlns="http://www.w3.org/2000/svg" viewBox="0 0 512 512"><path d="M67.508 468.467c-58.005-58.013-58.016-151.92 0-209.943l225.011-225.04c44.643-44.645 117.279-44.645 161.92 0 44.743 44.749 44.753 117.186 0 161.944l-189.465 189.49c-31.41 31.413-82.518 31.412-113.926.001-31.479-31.482-31.49-82.453 0-113.944L311.51 110.491c4.687-4.687 12.286-4.687 16.972 0l16.967 16.971c4.685 4.686 4.685 12.283 0 16.969L184.983 304.917c-12.724 12.724-12.73 33.328 0 46.058 12.696 12.697 33.356 12.699 46.054-.001l189.465-189.489c25.987-25.989 25.994-68.06.001-94.056-25.931-25.934-68.119-25.932-94.049 0l-225.01 225.039c-39.249 39.252-39.258 102.795-.001 142.057 39.285 39.29 102.885 39.287 142.162-.028A739446.174 739446.174 0 0 1 439.497 238.49c4.686-4.687 12.282-4.684 16.969.004l16.967 16.971c4.685 4.686 4.689 12.279.004 16.965a755654.128 755654.128 0 0 0-195.881 195.996c-58.034 58.092-152.004 58.093-210.048.041z"/></svg>Project1.exe</a>
</div>


Unit1.pas

Unit1.dfm

Project1.exe

<div>
<div class="content wysiwyg-content">
I write a function in Server side which will pass a OleVariant which is exported from a TADOQuery. &nbsp;Can I Load the oleVariant back to a TADOQuery or other other dataset that I can operate in Client Side?
</div>
</div>


I write a function in Server side which will pass a OleVariant which is exported from a TADOQuery.  Can I Load the oleVariant back to a TADOQuery or other other dataset that I can operate in Client Side?

How to assign OleVariant to a TDataSet

Delphi is the most powerful Object Pascal IDE and component library for cross-platform Native App Development with flexible Cloud services and broad IoT connectivity. It provides powerful VCL controls for Windows 10 and enables FMX development for Windows, Mac and Mobile. Delphi is your choice for ultrafast Enterprise Strong Development™. Look for increased memory for large projects, extended multi-monitor support, improved Object Inspector and much more. Delphi is 5x faster for development and deployment across multiple desktop, mobile, cloud and database platforms including 32-bit and 64-bit Windows 10.