• reitz
  • New member
  • Offline
  • Registered: 2014-07-14
  • Posts: 6

Topic: Read Line from Textfile in Database

Is it possible to read line nr. 2 for example from Textfile and add this value to field in database?

For example:

Textfile:
Hermle40   
Project: E:\0sc\Projects\Part1(SE).stc

I want to read line 2 and set to database in field "Project"

  • Registered: 2014-02-14
  • Posts: 10,294

Re: Read Line from Textfile in Database

Yes, example, how to open text file and read line nr.2

procedure Form1_Button1_OnClick (Sender: string; var Cancel: boolean);
var
   sl: TStringList;
begin
     sl := TStringList.Create;
     sl.LoadFromFile('d:\1.txt');
     if sl.Count > 1 then ShowMessage(sl[1]); // your  line nr.2 in sl[1]

     sl.Free;
end;

You want add this value in database using by SQL script?

Dmitry.