Jason:

So if you have 57,000,000 records going into the following table:

CREATE TABLE FLEA_STATUS (
FLEA_STAT_ID INTEGER, /* handled by generator */
NAME VARCHAR(45),
ANIMAL_STATUS INTEGER, /* 0 = NONE, CAT=1, DOG=2, BIRD=3, OTHER=4 */
HAS_FLEAS INTEGER ./* REALLY A BOOLEAN */
CONSTRAINT FLEA_STATUS_PK PRIMARY KEY (FLEA_STAT_ID));

You would create the following insert statement:

INSERT INTO FLEA_STATUS (NAME, ANIMAL_STATUS, HAS_FLEAS) VALUES
(:NAME, :ANIMAL_STATUS, :HAS_FLEAS);

Then from Delphi, loop through all 57,000,000 records, setting the
Parameters, and doing the insert from the TIB_Query?

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.

I will probably do this for my own use, I may make it available to
others, if others are interested. If you are interested or have
ideas, then please pass them on.

Paul














Paul

On 28 Aug 2001, at 18:11, Jason Wharton wrote:

To: <IBObjects@yahoogroups.com>
From: "Jason Wharton" <jwharton@...>
Date sent: Tue, 28 Aug 2001 18:11:34 -0700
Send reply to: IBObjects@yahoogroups.com
Subject: Re: [IBO] ib_export and *.sch file

> You handle just the data and use a parameterized INSERT statement.
>
> Jason Wharton
> CPS - Mesa AZ
> http://www.ibobjects.com
>
>
> ----- Original Message -----
> From: "Paul Schmidt" <paul@...>
> To: <IBObjects@yahoogroups.com>
> Sent: Tuesday, August 28, 2001 4:13 PM
> Subject: Re: [IBO] ib_export and *.sch file
>
>
> > Jason:
> >
> > On 28 Aug 2001, at 13:00, Jason Wharton wrote:
> >
> > > I suppose that could be a useful addition although it certainly
> > > isn't very efficient and would only be useful for smaller tables.
> > > Will it handle quotes correctly?
> > >
> >
> > So what do you do with larger tables? Other then inserting the
> > records one at a time through the INSERT statements in a IB_Script
> > control? Is there a way to make this process efficient?
> >
> >
> >
> >
> >
> >
> >
> >
> >
> > >
> > > ----- Original Message -----
> > > From: "Pirtea Calin" <pcalin@...>
> > > Newsgroups: egroups.ibobjects
> > > To: <IBObjects@yahoogroups.com>
> > > Sent: Tuesday, August 28, 2001 12:36 PM
> > > Subject: Re: [IBO] ib_export and *.sch file
> > >
> > >
> > > > ""Jason Wharton"" <jwharton@...> wrote in message
> > > > news:07ad01c12fea$694002e0$a9c90118@CX170673E...
> > > > > I think it is automatic but if you want to modify it to set a
> > > > > property
> > > and
> > > > > ignore creating it that would be fine with me. Make the
> > > > > changes and send
> > > > me
> > > > > the sources and I will merge in the changes.
> > > >
> > > > Speaking of IB_Export i use to backup the database to sql files
> > > > than when
> > > i
> > > > want a restore i simply re-run the sql files one by one on the
> > > > newly
> > > created
> > > > database. So i changed the component to also create sql files.
> > > > Do you want it?
> > > >
> > > > --
> > > > Regards,
> > > > Pirtea Calin.
> > > >
> > > > SoftScape - Software Development
> > > > pcalin@...
> > > >
> > > >
> > > >
> > > >
> > > >
> > > >
> > > >
> > > > Your use of Yahoo! Groups is subject to
> > > > http://docs.yahoo.com/info/terms/
> > > >
> > > >
> > >
> > >
> > > ------------------------ Yahoo! Groups Sponsor
> > > ---------------------~--> Get VeriSign's FREE GUIDE: "Securing
> > > Your Web Site for Business." Learn about using SSL for serious
> > > online security. Click Here!
> > > http://us.click.yahoo.com/KYe3qC/I56CAA/yigFAA/PhFolB/TM
> > > ------------------------------------------------------------------
> > > ---~ ->
> > >
> > >
> > >
> > > Your use of Yahoo! Groups is subject to
> > > http://docs.yahoo.com/info/terms/
> > >
> > >
> > >
> >
> >
> > Paul Schmidt,
> > Tricat Technologies
> > Email: paul@...
> > Website: www.tricattechnologies.com
>
>
>
> ------------------------ Yahoo! Groups Sponsor
> ---------------------~--> Do you need to encrypt all your online
> transactions? Secure corporate intranets? Authenticate your Web sites?
> Whatever security your site needs, you'll find the perfect solution
> here! http://us.click.yahoo.com/Bre3tC/Q56CAA/yigFAA/PhFolB/TM
> ---------------------------------------------------------------------~
> ->
>
>
>
> Your use of Yahoo! Groups is subject to
> http://docs.yahoo.com/info/terms/
>
>
>


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