Solved

loading sql file into delphi and executing it

Posted on 2003-11-11
3
193 Views
Last Modified: 2010-05-18
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
Comment
Question by:fadymoussallem
3 Comments
 
LVL 27

Expert Comment

by:kretzschmar
ID: 9722799
>is there a way to execute that file in delphi.
maybe
how looks the content of this files?
0
 
LVL 26

Accepted Solution

by:
EddieShipman earned 100 total points
ID: 9725234
 Query1.SQL.Clear;
  Query1.SQL.LoadFromFile('c:\myoutpulog1.log');
  Query1.ExecSQL;


should do it for you
0
 
LVL 9

Expert Comment

by:tkalchev
ID: 9741061
What is the database ?
0

Featured Post

How to run any project with ease

Manage projects of all sizes how you want. Great for personal to-do lists, project milestones, team priorities and launch plans.
- Combine task lists, docs, spreadsheets, and chat in one
- View and edit from mobile/offline
- Cut down on emails

Join & Write a Comment

The uses clause is one of those things that just tends to grow and grow. Most of the time this is in the main form, as it's from this form that all others are called. If you have a big application (including many forms), the uses clause in the in…
Introduction I have seen many questions in this Delphi topic area where queries in threads are needed or suggested. I know bumped into a similar need. This article will address some of the concepts when dealing with a multithreaded delphi database…
Illustrator's Shape Builder tool will let you combine shapes visually and interactively. This video shows the Mac version, but the tool works the same way in Windows. To follow along with this video, you can draw your own shapes or download the file…
Here's a very brief overview of the methods PRTG Network Monitor (https://www.paessler.com/prtg) offers for monitoring bandwidth, to help you decide which methods you´d like to investigate in more detail.  The methods are covered in more detail in o…

746 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

13 Experts available now in Live!

Get 1:1 Help Now