On 30 Aug 2001, at 0:11, Geoff Worboys wrote:

> > Then from Delphi, loop through all 57,000,000 records,
> > setting the Parameters, and doing the insert from the
> > TIB_Query?
>
> Dont use TIB_Query for imports/exports. Use TIB_Cursor or TIB_DSQL.
>
>
> > This seams to be a monumental PITA.... I wanted to
> > do this more as a utility, rather then having to do it
> > manually, I guess I could do somthing like a tab
> > delimited format. Think others might be interested
> > in a small utility that does this? Given an existing
> > table, a list of "fields" in the first row, then the
> > data in the remaining rows.
>
> Is there some reason you dont like the TIB_Export and TIB_Import
> components? If so check out the various "pump" utilities that are
> available around the place.

I don't have TIB_Import listed anywhere, I am using IBO4.2.E I am
also using D3, so maybe it needs a newer Delphi.... Strangely enough
TIB_Export is there, so I didn't think their was an Import Control...

> Another option is to remember that FB is free. About the only reasons
> for using an external format now is to transfer to/from other formats
> or non FB/IB users, otherwise just transfer from gdb to gdb using the
> datapump. Just a thought.

The data isn't currently in a .gdb, it's sitting in another type of
database, where it's only accessable from dos. So I need to export
it, and then import it.

Paul


Paul Schmidt,
Tricat Technologies
Email: paul@...
Website: www.tricattechnologies.com