How to use ADO & SQLServer in custom DataViews?

rbuser

I have read all the posts related to this issue and for the life of me still
can not get custom DataViews to work connecting via ADO to SQLServer.

Does anyone know of an example program or hints to get this working? What
methods have to be overridden to add fields to the pipeline. And how do you
handle the case of stored procedures? Obviously you can not add table or
select fields.

I have tried creating a descendant of TdaADOQueryDataView adding in my own
local TppChildADOQuery object and connecting pipelines etc but can not seem
to get a connection to the ADOSession?

Any help will do

Regards,

Jarrod

digitalmetaphors

There is a BDE custom dataview template example in the main end user demo
folder. This is the place to start. We don't have and ADO example, but it
should be very much like the BDE example when creating custom dataview
templates. If you have that figured out, then make sure the the
ADOConnection is owned by a form or datamodule in the application so that RB
can find it in the Screen.Forms[] and Screen.Datamodules[] array properties
when the session tries to find this component by name.


Cheers,

Jim Bennett
Digital Metaphors