🚀 go-pugleaf

I was in the same boat and was advised to move away from tables and use
datasets and queries.

if (datamod->Table1->FindFirst()) \\ don't need to do since queries start at
the frist record when opened.
could do something like....

ADOQuery1->Close();
ADOQuery1->SQL->Clear();
ADOQuery1->SQL->Add("select something from sometable where something =
somethingelse");
ADOQuery1->Open();
while(!ADOQuery->Eof)
{
   .... Do some code to retreive data.
  ADOQuery1->Next();
}

And to save to a table useing ADO you can use the datasets (ADODataset1  or
ADOCommand1 to insert new records. and update records.



"EDW" <aegis45@hotmail.com> wrote in message
news:40631630$1@newsgroups.borland.com...
> I'm converting an application that used the BDE with access to use ADO
> with access. I'm having a bit of difficulty when it comes to recognizing
> the methods with ADO that correspond to the methods used in BDE.
>
> I'm using a TADOconnection with TADOTables set to table direct.
>
> I use BDE Set Key() and  GotoKey() to extract data from linked tables. I
> would assume there is a similiar method with ADO but I'm not sure which
> they are. All I want to do there is set the current record and goto it.
>
> Also, for some reason, when I loop thru records it seems to go very very
> slow compared to the BDE version. Perhaps I'm not using the right methods.
>
>     if(datamod->Table1->FindFirst())
>     {
>        do
>        {
>           Application->ProcessMessages();
>
>
>           datamod->Table1->FieldValues["T_FIELD"]   = 0;
>           //...
>
>        }while(datamod->Table1->FindNext());
>      }
>
> I don't have much experience with ADO (This is my first app really) if
> anyone has any insight or can point me to a good resource to learn more
> about the ADO basics I'd be grateful.
>
>