The intention is to have a MS Access backend. Delphi app (middle tier) server handling
the access with only a small number of clients attached(hence Access wil do fine as
the backend). With Midas its easy to pass through a dynamic query. With ADO (via RDS)
it would seem I would have to pass my query via a custom method and then get to my
result back via a property off my server. (that is short of passing data back and
forth as OleVariants). I guess I am looking for a simular solution to what Midas
offers. Where by a lot of the work is done by a provider.
>
> From: "Neven MacEwan" <[EMAIL PROTECTED]>
> Date: 2000/11/22 Wed PM 01:06:14 GMT+12:00
> To: Multiple recipients of list delphi <[EMAIL PROTECTED]>
> Subject: Re: Re: [DUG]: ADO and Remote Datasets
>
> So do you want to 'pass thru' the middle tier in this case?
>
> Its prob not a problem with ADOExpress per se what you prob
> need to do is access properties of the ResordSet directly
>
> I'll do some research and get back
>
> Neven
>
>
> ----- Original Message -----
> From: <[EMAIL PROTECTED]>
> To: Multiple recipients of list delphi <[EMAIL PROTECTED]>
> Sent: Wednesday, 22 November 2000 12:58
> Subject: Re: Re: [DUG]: ADO and Remote Datasets
>
>
> > 3 Tier is what I'm after. Just like in the RDS demo. ADO Express
> components dont seem to offer the functionality I'm after in 3-Tier (that is
> without making your own modifications). I wondering if D6 will be bring more
> functionality to the ADO suite? For now it seems Midas is still my best
> solution.
> >
> >
> > > ----------------------------------------------------
> > > Alan
> > >
> > > Then dont bother using RDSconnection (it is only useful if you want a
> middle
> > > layer)
> > > Just use an ADOConnection and a ClientSide dataset
> > >
> > > HTH
> > > Neven
> > >
> > >--------------------------------------------
> > >
> > > > I am currently looking at ADO as an alternative to Midas. Ive seen
> the D5
> > > > demo (RDS) where via an RDSconnection they have hooked an ADODataset
> to a
> > > > recordset property on a RemoteServer. However Id like to be able to
> send
> > > a
> > > > dynamic query to my server, which then executes my query and returns
> the
> > > > recordset.
> > > > Delphi help says:
> > > > The CommandText property should either specify the name of a property
> on
> > > > the associated business object or be an SQL query. (or is this
> misleading
> > > > and they are talking about a direct connection to a DB)
> > > > Does anyone know how you go about implementing this feature or seen
> > > anything
> > > > on the net about this. Thanks in advance.
> > > >
> > >
> > --------------------------------------------------------------------------
> > > -
> > > > New Zealand Delphi Users group - Delphi List -
> [EMAIL PROTECTED]
> > > > Website: http://www.delphi.org.nz
> > > > To UnSub, send email to: [EMAIL PROTECTED]
> > > > with body of "unsubscribe delphi"
> > > >
> > >
> >
> > --------------------------------------------------------------------------
> -
> > > New Zealand Delphi Users group - Delphi List - [EMAIL PROTECTED]
> > > Website: http://www.delphi.org.nz
> > > To UnSub, send email to: [EMAIL PROTECTED]
> > > with body of "unsubscribe delphi"
> > >
> >
> > --------------------------------------------------------------------------
> -
> > New Zealand Delphi Users group - Delphi List - [EMAIL PROTECTED]
> > Website: http://www.delphi.org.nz
> > To UnSub, send email to: [EMAIL PROTECTED]
> > with body of "unsubscribe delphi"
> >
>
> ---------------------------------------------------------------------------
> New Zealand Delphi Users group - Delphi List - [EMAIL PROTECTED]
> Website: http://www.delphi.org.nz
> To UnSub, send email to: [EMAIL PROTECTED]
> with body of "unsubscribe delphi"
>
---------------------------------------------------------------------------
New Zealand Delphi Users group - Delphi List - [EMAIL PROTECTED]
Website: http://www.delphi.org.nz
To UnSub, send email to: [EMAIL PROTECTED]
with body of "unsubscribe delphi"