At 09:44 AM 14-01-02 +0100, you wrote:

>I am new to Firebird and the SQL world, so this will be a stupid question
>to many (sorry).
>
>I have to trasfer a few hundreds of records from a DBF table.
>
>I wrote (programmatically) a large SQL script with an INSERT instruction
>for each record to transfer.
>
>Now I find that WISQL won't write it ("buffer exceeded").
>
>How do I run a large SQL script against IB ?

Duilio,

1. Break the script up into smaller scripts.
or
2. Use the command-line isql (in the ../bin directory of your FB or IB installation)
or
3. Use a tool that doesn't have a buffer limit on scripts (WISQL is an old old tool anyway) - you can download ib_sql for free from www.ibobjects.com, which has a good script tool.
or
4. Don't use this way to pump the data. If you have Delphi or BCPPB, you might find the Database Desktop will serve you better; or get hold of an import tool.
or
5. There is a tool on the ibobjects site (see the TechInfo page) for converting Paradox and DBase tables (BDE on the Paradox/DBase side, ibobjects on the IB/FB side) which assists by creating a script for the database (which you can modify) and then pumps the data.

cheers,
Helen


All for Open and Open for All
Firebird Open SQL Database · http://firebirdsql.org
_______________________________________________________