• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 217
  • Last Modified:

loading sql file into delphi and executing it

hi there ,
i have a list of generated sql scripts log file (myoutputlog1.log,myoutputlog2.log,myoutputlog3.log,.......)
i receive them by email, i am execute the sql file so that i can insert to a databse the data include in the file. is there a way to execute that file in delphi.
please help
0
fadymoussallem
Asked:
fadymoussallem
1 Solution
 
kretzschmarCommented:
>is there a way to execute that file in delphi.
maybe
how looks the content of this files?
0
 
Eddie ShipmanAll-around developerCommented:
 Query1.SQL.Clear;
  Query1.SQL.LoadFromFile('c:\myoutpulog1.log');
  Query1.ExecSQL;


should do it for you
0
 
tkalchevCommented:
What is the database ?
0

Featured Post

Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Tackle projects and never again get stuck behind a technical roadblock.
Join Now