<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD><TITLE></TITLE>
<META http-equiv=Content-Type content=text/html;charset=ISO-8859-1>
<META content="MSHTML 6.00.2800.1400" name=GENERATOR>
<STYLE></STYLE>
</HEAD>
<BODY text=#000000 bgColor=#ffffff>
<DIV><FONT face=Arial size=2>Thanks Rob, I will check them
out.</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2>Phil.</FONT></DIV>
<DIV><FONT face=Arial size=2>p.s. The first sentence of the previous post was a
typo - it was meant to read "Sorry for the lack of clarity" - talk about
ironic!</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<BLOCKQUOTE
style="PADDING-RIGHT: 0px; PADDING-LEFT: 5px; MARGIN-LEFT: 5px; BORDER-LEFT: #000000 2px solid; MARGIN-RIGHT: 0px">
<DIV style="FONT: 10pt arial">----- Original Message ----- </DIV>
<DIV
style="BACKGROUND: #e4e4e4; FONT: 10pt arial; font-color: black"><B>From:</B>
<A title=rob@wildsoft.co.nz href="mailto:rob@wildsoft.co.nz">Robert martin</A>
</DIV>
<DIV style="FONT: 10pt arial"><B>To:</B> <A title=delphi@ns3.123.co.nz
href="mailto:delphi@ns3.123.co.nz">NZ Borland Developers Group - Delphi
List</A> </DIV>
<DIV style="FONT: 10pt arial"><B>Sent:</B> Friday, January 21, 2005 9:04
AM</DIV>
<DIV style="FONT: 10pt arial"><B>Subject:</B> Re: [DUG] Interbase/Firebird
Filters</DIV>
<DIV><BR></DIV>Hi Phil<BR><BR>Don't know about the IB components but If you
are going to do some serious FB development and aren't yet committed to the
component set, you should check out the IBObjects components. They are
fantastic and include the script component you mention below.
<BR><BR>Rob<BR><BR><BR>Phil Middlemiss wrote:
<BLOCKQUOTE cite=mid03ea01c4ff25$3af2f3d0$0a01a8c0@mts32cus type="cite"><PRE wrap="">So for the lack of clarity, I basically want to be able to run an SQL script
that contains maybe a couple of INSERTs, and a few UPDATEs all at once,
rather than formulating each one and executing it individually. The VCL
components all seem to be limited to executing one statement at a time
(unless I'm doing something very wrong). The only reason I started off
assuming I could do this, is because the Firebird management tool I use (EMS
Firebird Manager) allows you to run an SQL script.
Phil.
----- Original Message -----
From: "Craig Goodall" <A class=moz-txt-link-rfc2396E href="mailto:Craig.Goodall@shire.net.au"><Craig.Goodall@shire.net.au></A>
To: "NZ Borland Developers Group - Delphi List" <A class=moz-txt-link-rfc2396E href="mailto:delphi@ns3.123.co.nz"><delphi@ns3.123.co.nz></A>
Sent: Thursday, January 20, 2005 9:06 PM
Subject: Re: [DUG] Interbase/Firebird Filters
</PRE>
<BLOCKQUOTE type="cite">
<BLOCKQUOTE type="cite"><PRE wrap="">I want to execute several SQL commands at once, but the Interbase
</PRE></BLOCKQUOTE></BLOCKQUOTE><PRE wrap=""><!---->components
</PRE>
<BLOCKQUOTE type="cite">
<BLOCKQUOTE type="cite"><PRE wrap="">all seem to be limited to carrying out a single command at a time (even
</PRE></BLOCKQUOTE></BLOCKQUOTE><PRE wrap=""><!---->the
</PRE>
<BLOCKQUOTE type="cite">
<BLOCKQUOTE type="cite"><PRE wrap="">TIBSQL). Is there any way around this?
</PRE></BLOCKQUOTE><PRE wrap="">Sorry, Phil. I'm not sure what you mean. Can you give an example?
Craig.
_______________________________________________
Delphi mailing list
<A class=moz-txt-link-abbreviated href="mailto:Delphi@ns3.123.co.nz">Delphi@ns3.123.co.nz</A>
<A class=moz-txt-link-freetext href="http://ns3.123.co.nz/mailman/listinfo/delphi">http://ns3.123.co.nz/mailman/listinfo/delphi</A>
</PRE></BLOCKQUOTE><PRE wrap=""><!---->
_______________________________________________
Delphi mailing list
<A class=moz-txt-link-abbreviated href="mailto:Delphi@ns3.123.co.nz">Delphi@ns3.123.co.nz</A>
<A class=moz-txt-link-freetext href="http://ns3.123.co.nz/mailman/listinfo/delphi">http://ns3.123.co.nz/mailman/listinfo/delphi</A>
</PRE></BLOCKQUOTE><BR>
<P>
<HR>
<P></P>_______________________________________________<BR>Delphi mailing
list<BR>Delphi@ns3.123.co.nz<BR>http://ns3.123.co.nz/mailman/listinfo/delphi<BR></BLOCKQUOTE></BODY></HTML>