ADO

Posted by Mary Streetland on September 02, 2010

Hi,

I have always used BDE and want to use ADO instead. However, it's not working yet. What I want to do is import a database from a local drive. I want to import a file that can be found on C:\Project\Input.dbf. How do I make the right connection? Can I do it with just a TADOTable? What do I need to fill in for connectionstring? I just want a simple connection, no passwords of other kind of things.

When I have made the right connection, is the code below appropriate to read it?

Mainform.Trucktable.Active := false;
Mainform.Trucktable.TableName := FileName;
Mainform.Trucktable.active := true;
Mainform.Trucktable.first;

while not Mainform.TruckTable.eof do begin
  Nr:=Nr+1;
  Capacity:=Mainform.Trucktable.FieldByName('Capacity').AsInteger;
  Mainform.TruckTable.Next;
end; {while}

Mainform.TruckTable.Active := false;

You would help me a lot, thanks!