Re: Master / detail with TADODataset?


>Yes easily, use Datasource property.
>Set the Details.Datasource to a datasource linked to the Master, and the
>Details.MasterFields to the name(s) of the Master fields. If Details has
>different field names to the Master then set Details.IndexFieldNames to the
>matching Details fields.

Alternately you can set the CommandText property to a query where any parameters
you use that match fields from the Dataset DATASOURCE property points to will
get values from the current record of DATASOURCE.dataset


--
Brian Bushay (TeamB)
Bbushay@xxxxxxxxx
.

Relevant Pages

  • Re: Master / detail with TADODataset?
    ... informática Green Service SA ... > Yes easily, use Datasource property. ... > and the Details.MasterFields to the nameof the Master fields. ... > matching Details fields. ...
    (borland.public.delphi.database.ado)
  • Re: Using BatchOptimistic locking with Master/Details
    ... "Brian Bushay TeamB" wrote ... > If you are linking your master and Detail tables using Parameters in the ... > If you just link them using the DataSource property and the MasterFields ... I was linking using Parameters. ...
    (borland.public.delphi.database.ado)
  • Re: Using BatchOptimistic locking with Master/Details
    ... >The details are linked to the master (both ADODatasets with BatchOptimistic ... >and LocalClient cursor) via Datasource. ... >Master changes e.g when an edit posted, ... If you just link them using the DataSource property and the MasterFields ...
    (borland.public.delphi.database.ado)
  • Re: messagebox.show produces error???
    ... Jack of all trades, master of none. ... Prev by Date: ...
    (microsoft.public.dotnet.languages.vc)
  • Re: Connecting to "HP NonStop SQL"
    ... Jack of all trades, master of none. ... Prev by Date: ...
    (microsoft.public.dotnet.framework.adonet)