Hi Phil, How about create a new temp table with VarChar(20) and write a delphi utility application to copy everything to that table? Once data in that temp table, you may drop original one and recreate original one.
Regards Leigh www.smootharm.com -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Phil Middlemiss Sent: Monday, 8 May 2006 1:59 p.m. To: NZ Borland Developers Group - Delphi List Subject: [DUG] Change a VarChar(255) into a VarChar(20) - Firebird I have an Firebird database with a field that stores a small string value in a VarChar(255). I want to change that now to a VarChar(20) which is plenty big enough so that I can create an index on it. But of course, Firebird won't let me reduce the varchar size since it is already populated (although no values over 20 chars long). Any ideas? Cheers, Phil. _______________________________________________ Delphi mailing list [email protected] http://ns3.123.co.nz/mailman/listinfo/delphi
