Hi
We in the Clarion world can buy a 3rd party tool called File Manager 3
(http://www.capesoft.com) that will do it (Changing field size to smaller)
for us, without any problems. It should cater for Firebird very soon,
already works for MS SQL, MySQL etc.
Cheers
JVZ
-----Original Message-----
From: Martijn Tonies [mailto:m.tonies@...]
Sent: 10 August 2004 12:58
To: firebird-support@yahoogroups.com
Subject: Re: [firebird-support] Changing field size to smaller


Hi,

> I want to write SQL script for database modification.
> Can someone tell me is it possible to change existing varchar(200) field
> into varchar(150) when the table contains data longer than 150 symbols.
> Currently I get truncation error when trying to update data from longer
> field to shorter.

The only way to do this is to create a new column,
move the data and drop the old column.

With regards,

Martijn Tonies
Database Workbench - developer tool for InterBase, Firebird, MySQL & MS
SQL
Server.
Upscene Productions
http://www.upscene.com


Yahoo! Groups Sponsor
ADVERTISEMENT





----------------------------------------------------------------------------
--
Yahoo! Groups Links

a.. To visit your group on the web, go to:
http://groups.yahoo.com/group/firebird-support/

b.. To unsubscribe from this group, send an email to:
firebird-support-unsubscribe@yahoogroups.com

c.. Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.


---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.736 / Virus Database: 490 - Release Date: 2004/08/09


[Non-text portions of this message have been removed]