Hi everybody,
I have a problem, I'm working with excel to do some inserts
stataments depending on what information I must upload to the IBASE. I have
Date Constants, like '10-JAN-01', how it must be in the SQL statament, is
like:

Insert into WorkTable (Field1, Field2, ..., TimeStampField, ...)
values (x,x, ..., '10-JAN-01', ...)

??
I'm working with IB6

Thank in advance.

Best Regards,

______________________________________________________
Hernán Galante
"The best way to predict the future is to invent it " by Alan Kay

> -----Mensaje original-----
> De: _a_x_e_ [SMTP:_a_x_e_@...]
> Enviado el: Martes 12 de Febrero de 2002 10:04
> Para: ib-support@yahoogroups.com
> Asunto: [ib-support] Re: DB-file growth VERY rapidly!??
>
> Hello Paul,
>
> it is a Perl-Script running on Debian-Linux, connecting to an Firebird
> RC2 Server (running on another host, Debian-Linux too) using DBI für
> connection.
>
> No special transaction isolation, I use standard settings (should be
> READ-WRITE, SNAPSHOT, WAIT)
>
> My problem is not that data is not written into the database, that
> works fine, ALL data is correctly written into the database during the
> transactions, the problem is the enormous and rapid growing of the
> database file, also the RAW data is MUCH smaller, the database-file
> still continues growing even if there are ONLY updates! This space
> seems to be never freed and used again, sweep does not help, database
> restart does not help, only backup restore helps, but then file-size
> continues to grow in same speed. 8 MB per day for only 160kb raw data
> is too much!?
>
>
> --- In ib-support@y..., Paul Reeves <paul@f...> wrote:
> > _a_x_e_ wrote:
> > >
> > > Hello Sven,
> > >
> > > here are three page-header-statistics, during this three update runs
> > > the DB-file-size increased by 60kb per run. I don't know exactly if Ia
> > > see it right, transaction 105 is hanging!??
> > >
> > > Oldest transaction 104
> > > Oldest active 105
> > > Oldest snapshot 105
> > > Next transaction 12680
> >
> >
> > What middleware are you using?
> > What transaction isolation settings are you using?
> >
> > Paul
> > --
> >
> > Paul Reeves
> > http://www.ibphoenix.com
> > taking InterBase further
>
>
>
> To unsubscribe from this group, send an email to:
> ib-support-unsubscribe@egroups.com
>
>
>
> Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/
>