Execute SQL script

Article View: borland.public.cppbuilder.database.ado

Article #2125

Back to borland.public.cppbuilder.database.ado Previous Next

#2125

From: Johny
Date: Sun, 09 Nov 2003 18:35

13 lines
1229 bytes

I want to execute SQL script from a file.

When I try to do something like this:

TStringList *sl = new TStringList;

sl->LoadFromFile(dlgOpen->FileName);

 adoconection->Execute(sl->Text, cmdText, TExecuteOptions());

I get errors because of inserted marks for end of line and similar.

How can I execute script on some other way?

Technical Details

Message-ID: <3fae8979@newsgroups.borland.com>

Path:

arc1-ca.pugleaf.net!archiver1.google.com!news2.google.com!news.maxwell.syr.edu!news.tele.dk!news.tele.dk!small.news.tele.dk!newsfeed00.sul.t-online.de!newsfeed01.sul.t-online.de!t-online.de!newsgroups.borland.com!not-for-mail

Show Full Headers

Complete Article Headers

X-Google-Language: ENGLISH,ASCII-7-bit
X-Google-Thread: 10698b,7c392a6aca5fdbdc,start
X-Google-Attributes: gid10698b,public
X-Google-ArrivalTime: 2003-11-09 10:39:15 PST
From: "Johny" <goky2002@beograd.com>
Newsgroups: borland.public.cppbuilder.database.ado
Subject: Execute SQL script
Date: Sun, 9 Nov 2003 19:35:12 +0100
Lines: 16
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2800.1106
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1106
NNTP-Posting-Host: 213.137.120.141
Message-ID: <3fae8979@newsgroups.borland.com>
X-Trace: newsgroups.borland.com 1068403065 213.137.120.141 (9 Nov 2003 10:37:45 -0700)
Path: arc1-ca.pugleaf.net!archiver1.google.com!news2.google.com!news.maxwell.syr.edu!news.tele.dk!news.tele.dk!small.news.tele.dk!newsfeed00.sul.t-online.de!newsfeed01.sul.t-online.de!t-online.de!newsgroups.borland.com!not-for-mail