0

I have passed TDataSet.Recordset: _Recordset interface using COM method outside the application. But I see there a wild DB data. How can I get access to Delphi's TField.DisplayText from _Recordset ADO interface? (TField.DisplayText shows data after OnGetText conversion.)

Dmitry
  • 14,306
  • 23
  • 105
  • 189
  • 1
    ADO [`Recordset`](http://msdn.microsoft.com/en-us/library/windows/desktop/ms681510(v=vs.85).aspx) object doesn't know anything about how you display your data, so either create a new `_RecordSet` instance and fill it with `DisplayText` values and pass that object, or pass the way you're converting your data to that application separately (which would actually need to pass the code of your `OnGetText` event method). – TLama Apr 20 '14 at 19:12
  • But how can I create and fill _RecordSet instance? :( – Dmitry Apr 20 '14 at 19:41
  • Yet one more thing we need to know. What are you going to do with that dataset in the other application ? Are you going to modify it so the changes will apply to the underlying data source, or can it figure just as an independent in-memory table ? – TLama Apr 20 '14 at 20:29
  • "But how can I create and fill _RecordSet instance?" Have you looked at the RecordSet interface in AdoInt.Pas? – MartynA Apr 20 '14 at 20:36
  • Just independent in-memory table. – Dmitry Apr 20 '14 at 20:41
  • Similar question: http://stackoverflow.com/questions/13605901/how-to-export-tadodataset-with-fields-texts-not-fields-values/13607532#13607532 – Dmitry Apr 29 '14 at 15:11

1 Answers1

1

Thanks TLama for the answer:

ADO Recordset object doesn't know anything about how you display your data, so either create a new _RecordSet instance and fill it with DisplayText values and pass that object, or pass the way you're converting your data to that application separately (which would actually need to pass the code of your OnGetText event method).

Dmitry
  • 14,306
  • 23
  • 105
  • 189