multiline sql statement

Article View: borland.public.interbase.sql

Article #1009

Back to borland.public.interbase.sql Previous Next

#1009

From: AntonE
Date: Fri, 02 Mar 2007 20:59

7 lines
1079 bytes

Which component can I use to make a multiline sql script run?
I have a multiple line INSERT INTO...  .sql file which executes fine in 
IBConsole's interactive SQL, but in IBSQL & IBQuery components, they give 
error on line 2

Thanks
Ekkas

Technical Details

Message-ID: <45e89040@newsgroups.borland.com>

Path:

arc1-ca.pugleaf.net!g2news2.google.com!news2.google.com!news.germany.com!newsfeed.freenet.de!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-Thread: 114a0e,7028cd70cd31d58b,start
X-Google-Attributes: gid114a0e,public
X-Google-Language: ENGLISH,ASCII-7-bit
From: "AntonE" <antone@true.co.za>
Newsgroups: borland.public.interbase.sql
Subject: multiline sql statement
Date: Fri, 2 Mar 2007 22:59:45 +0200
Lines: 9
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2900.3028
X-RFC2646: Format=Flowed; Original
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.3028
NNTP-Posting-Host: 196.34.167.130
Message-ID: <45e89040@newsgroups.borland.com>
X-Trace: newsgroups.borland.com 1172869184 196.34.167.130 (2 Mar 2007 12:59:44 -0800)
Path: arc1-ca.pugleaf.net!g2news2.google.com!news2.google.com!news.germany.com!newsfeed.freenet.de!newsfeed00.sul.t-online.de!newsfeed01.sul.t-online.de!t-online.de!newsgroups.borland.com!not-for-mail