<div>
firebird comes with an isql tool, you can run isql supplying a filename on the command line, will that do what you are trying to achieve? if not please explain what you expect &quot;a function like batch or run scripts &quot;&nbsp;to actually do
</div>


<div>
Thanks for your information. <br />
(Sorry about my English)<br />
<br />
Example: cn is a connection. I can execute a single command like cn.execute &quot;ALTER TABLE ....&quot;. <br />
<br />
If I try to execute an external file like update.sql with a lot of commands, so I have to separate each command. What Im looking for is like IBExperts Script Executive. So I can open a file or take a string from an update-table and send it to FIREBIRD.<br />

</div>


<div>
The only way I can think of is for VB to run the isql program as I described earlier, there in nothing else in firebird itself that can do this. There may be something in VB but that's not my area.
</div>


<div>
AFAIR, the method used to run scripts is the ExecImmediate. Verify if this API is exposed by the driver you use.<br />
<br />
If you're stuck, you could use Nick's approach which will work - since it already works for tons of apps around the world for many years.<br />
<br />
<br />

</div>


<div>
Just remember when you run the script to include the SET TERM statement to the trigger you wanna create when you wrote the question.<br />

</div>


<div>
<div class="content wysiwyg-content">
Hy. Im a genius in databases but a greenhorn in Firebird. So I'm looking for some (easy) answers.<br />
I have an external script like CREATE TRIGGER .... It works fine in FIREBIRD using IBExpert. Connection, Pw, Role... &nbsp; is known and ok. &nbsp;For easy handling of updates I will run an external script in VB. In the script are a list of commands. <br />
<br />
Is there a function like batch or run scripts working with FIREBIRD ?<br />

</div>
</div>


Hy. Im a genius in databases but a greenhorn in Firebird. So I'm looking for some (easy) answers.
I have an external script like CREATE TRIGGER .... It works fine in FIREBIRD using IBExpert. Connection, Pw, Role...   is known and ok.  For easy handling of updates I will run an external script in VB. In the script are a list of commands. 

Is there a function like batch or run scripts working with FIREBIRD ?


How execute a externen Script (CREATE Trigger ...) IN VB / FIREBIRD

Visual Basic is Microsoft’s event-driven programming language and integrated development environment (IDE) for its Component Object Model (COM) programming model. It is relatively easy to learn and use because of its graphical development features and BASIC heritage. It has been replaced with VB.NET, and is very similar to VBA (Visual Basic for Applications), the programming language for the Microsoft Office product line.

Visual Basic Classic

VBScript (Visual Basic Scripting Edition) is an interpreted scripting language developed by Microsoft that is modeled on Visual Basic, but with some important differences. VBScript is commonly used for automating administrative and other tasks in Windows operating systems (by means of the Windows Script Host) and for server-side scripting in ASP web applications. It is also used for client-side scripting in Internet Explorer, specifically in intranet web applications.

VB Script

Databases are organized collections of data, most commonly accessed through management systems including schemas, tables, queries and processes that allow users to enter and manipulate the information or utilize it in other fashions, such as with web applications or for reporting purposes.