🚀 go-pugleaf

You may have three similar datasets and attach each edit to its own dataset.
Place three TADODataSet to form, connect one to data and then do

ADODataSet2->Recordset = ADODataSet1->Recordset;
ADODataSet3->Recordset = ADODataSet1->Recordset;

Now you have 3 datasets that use the same ADO recordset object. You can set
position in every dataset independently of others.

----------------------------------------------------------------
Regards,
Viatcheslav V. Vassiliev
http://www.oledbdirect.com
The fastest way to access MS SQL Server, MS Jet (MS Access)
and Interbase (through OLEDB) databases.

"Lee" <gobroski@elltel.net> �������/�������� � �������� ���������:
news:3f5058da$1@newsgroups.borland.com...
> Viatcheslav,
>
> Thanks, that worked great.  I was wondering if I can have three DBText
> labels all displaying different records on the same table.
>
> Like:
> DBText1 = Record 1
> DBText1 = Record 2
> DBText1 = Record 3
>
> Thanks for you help
>
> Lee
>
>
> "Viatcheslav V. Vassiliev" <support@oledbdirect.com> wrote in message
> news:3f4f120b$1@newsgroups.borland.com...
> > Look TDBNavigator component. You can traverse dataset with TDataSet
> method,
> > so you should call ADODataSet1->First(), ADODataSet1->Next() etc.
> >
> > ----------------------------------------------------------------
> > Regards,
> > Viatcheslav V. Vassiliev
> > http://www.oledbdirect.com
> > The fastest way to access MS SQL Server, MS Jet (MS Access)
> > and Interbase (through OLEDB) databases.
> >
> > "Lee" <gobroski@elltel.net> �������/�������� � �������� ���������:
> > news:3f4eff11@newsgroups.borland.com...
> > > OK, here is what I am trying to do.
> > >
> > >
> > >
> > > I would like to read the names out of an Access table that I have
> > populated
> > > using ADO methods.  The fields in the database are as fallows SID,
LAST,
> > > FIRST.  Now I only need to show the First and Last fields, and that is
> > easy
> > > I have that showing, but how do I change records to show the next set.
> > >
> > >
> > >
> > > This is what I am using to connect to the table:
> > >
> > > //data is the data module
> > >
> > > //DataSource is just a standard TDataSouce and that connects to the
> > > ADODataset
> > >
> > > DBText1->DataSource = Data->DataSource;
> > >
> > > //Datafield is Last
> > >
> > > DBText2->DataSource = Data->DataSource;
> > >
> > > //Datafield is First
> > >
> > >
> > >
> > > Is there a way I can choose what record set to display
> > >
> > >
> > >
> > > First record John Smith
> > >
> > > Click a Button
> > >
> > > Second record Jane Doe
> > >
> > > And so forth.
> > >
> > >
> > >
> > > Thanks for your help.
> > >
> > >
> > >
> > > Lee
> > >
> > >
> >
> >
>
>