Solved

loading sql file into delphi and executing it

Posted on 2003-11-11
3
196 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

Live: Real-Time Solutions, Start Here

Receive instant 1:1 support from technology experts, using our real-time conversation and whiteboard interface. Your first 5 minutes are always free.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
Delphi XE10, DigitalPersona Fingerprint reader and MySQL 6 264
delphi exception 7 64
QRReport  TQrmemo vertical stretching 1 45
Magic Software info 18 130
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…
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…
Although Jacob Bernoulli (1654-1705) has been credited as the creator of "Binomial Distribution Table", Gottfried Leibniz (1646-1716) did his dissertation on the subject in 1666; Leibniz you may recall is the co-inventor of "Calculus" and beat Isaac…
With Secure Portal Encryption, the recipient is sent a link to their email address directing them to the email laundry delivery page. From there, the recipient will be required to enter a user name and password to enter the page. Once the recipient …

776 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