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('Capacit y').AsInteger;
    Mainform.TruckTable.Next;
  end;

  Mainform.TruckTable.Active := false;

You would help me a lot, thanks!

Follow Ups

Post a Followup

Name:
Password:

Subject:

Comments:
: 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('Capacit y').AsInteger; : Mainform.TruckTable.Next; : end; {while} : Mainform.TruckTable.Active:=false; : You would help me a lot, thanks!

DelphiLand Club members: enter your Membership password.
Guests can get a Forum Guest password by subscribing to the DelphiLand Newsletter.