Thanks for the tip....I'll try that. Does W2k come with Ms Backup ?

-----Original Message-----
From: Randal W. Carpenter [mailto:wade@...]
Sent: Tuesday, June 13, 2000 12:21 PM
To: 'IBDI@egroups.com'
Subject: Re: [IBDI] Installation Problem on W2K - solution...

4. Backup the new MSVCRT.DLL using ms backup and restore it into system32
directory...worked for me. I had it in \TEMP\System32 and restored it to
\WINDOWS\System32.

Randal

On Mon, 12 Jun 2000, Shiv Kumar wrote:

> Hi,
> I'm having a terrible time trying to get rid of the old version on
> MSVCRT.DLL after Interbase 6 was installed. This has broken a lot of
> software and has come to a point that I have reformat my HDD and install
all
> the software but not install Interbase.
>
> It seems that this file (once installed by the Interbase installation
> program) is untouchable by any other installation program. Giving an error
> of read-only status (which it is not). I've tried all kinds of things, but
> with no success.
>
> Here is the plan,
> 1. Either make the installation W2K compliant (using the W2K installation
> API)
> 2. I can give you the latest version of MSVCRT.DLL to be used in your
> installation.
> 3. Let us know what files need to be put where and we (W2K users) can
> manually install Interbase on our machines.
>
> Regards,
>
> Shiv.
>
>
> -----Original Message-----
> From: Claudio Valderrama C. [mailto:cvalde@...]
> Sent: Sunday, June 11, 2000 7:46 PM
> To: IBDI@egroups.com
> Subject: RE: [IBDI] Defining a default value to an existing column
>
> Here's a safe way:
>
> select rdb$field_source
> from rdb$relation_fields
> where rdb$field_name = 'OR_SITUATION'
> and rdb$relation_name = 'ORDERS'
>
> This will give your a name like rdb$15, then using this example, you would
> do
>
> ALTER DOMAIN rdb$15 SET DEFAULT '10000000';
> commit;
>
> This form of the alter domain syntax exists since IB4.0.
>
> Now if your table has records, update them now to avoid on-the-fly
> conversion (and hence, overhead) to the new definition each time you do a
> query:
>
> update orders set or_situation = or_situation;
> select * from orders;
> commit;
>
> C.
>
> > -----Original Message-----
> > From: Paulo Albuquerque [mailto:paulo.albuquerque@...]
> > Sent: Jueves 8 de Junio de 2000 10:17
> > To: IBDI@egroups.com
> > Subject: [IBDI] Defining a default value to an existing column
> >
> >
> > What is the command syntax for defining a default value to an
> > existing column on a Interbase 6.0 table on WISQL ?
> > I tried something like:
> >
> > ALTER TABLE ORDERS ALTER COLUMN OR_SITUATION TYPE VARCHAR(8)
> > DEFAULT '10000000';
> >
> > but it always returns a SQL error.
> >
> > Thank you in advance,
> >
> > Paulo
> >
> >
> >
> > ------------------------------------------------------------------------
> > Take your development to new heights. Work with clients like Dell and
> > pcOrder. Submit your resume to jobs@.... Visit us at
> > http://click.egroups.com/1/4358/4/_/679568/_/960473816/
> > ------------------------------------------------------------------------
> >
> > Community email addresses:
> > Post message: IBDI@onelist.com
> > Subscribe: IBDI-subscribe@onelist.com
> > Unsubscribe: IBDI-unsubscribe@onelist.com
> > List owner: IBDI-owner@onelist.com
> >
> > Shortcut URL to this page:
> > http://www.onelist.com/community/IBDI
> >
>
>
> ------------------------------------------------------------------------
> Free @Backup service! Click here for your free trial of @Backup.
> @Backup is the most convenient way to securely protect and access
> your files online. Try it now and receive 300 MyPoints.
> http://click.egroups.com/1/4935/4/_/679568/_/960767361/
> ------------------------------------------------------------------------
>
> Community email addresses:
> Post message: IBDI@onelist.com
> Subscribe: IBDI-subscribe@onelist.com
> Unsubscribe: IBDI-unsubscribe@onelist.com
> List owner: IBDI-owner@onelist.com
>
> Shortcut URL to this page:
> http://www.onelist.com/community/IBDI
>
> ------------------------------------------------------------------------
> Take your development to new heights. Work with clients like Dell and
> pcOrder. Submit your resume to jobs@.... Visit us at
> http://click.egroups.com/1/4358/4/_/679568/_/960827429/
> ------------------------------------------------------------------------
>
> Community email addresses:
> Post message: IBDI@onelist.com
> Subscribe: IBDI-subscribe@onelist.com
> Unsubscribe: IBDI-unsubscribe@onelist.com
> List owner: IBDI-owner@onelist.com
>
> Shortcut URL to this page:
> http://www.onelist.com/community/IBDI
>


------------------------------------------------------------------------
Take your development to new heights. Work with clients like Dell and
pcOrder. Submit your resume to jobs@.... Visit us at
http://click.egroups.com/1/4358/4/_/679568/_/960917152/
------------------------------------------------------------------------

Community email addresses:
Post message: IBDI@onelist.com
Subscribe: IBDI-subscribe@onelist.com
Unsubscribe: IBDI-unsubscribe@onelist.com
List owner: IBDI-owner@onelist.com

Shortcut URL to this page:
http://www.onelist.com/community/IBDI