Solved

loading sql file into delphi and executing it

Posted on 2003-11-11
3
205 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
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

Industry Leaders: 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!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Hello everybody This Article will show you how to validate number with TEdit control, What's the TEdit control? TEdit is a standard Windows edit control on a form, it allows to user to write, read and copy/paste single line of text. Usua…
Introduction Raise your hands if you were as upset with FireMonkey as I was when I discovered that there was no TListview.  I use TListView in almost all of my applications I've written, and I was not going to compromise by resorting to TStringGrid…
NetCrunch network monitor is a highly extensive platform for network monitoring and alert generation. In this video you'll see a live demo of NetCrunch with most notable features explained in a walk-through manner. You'll also get to know the philos…
This is my first video review of Microsoft Bookings, I will be doing a part two with a bit more information, but wanted to get this out to you folks.

724 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