Fair enough. Just wondered if there was a tool already out there that
did it. As it turns out, some of the data in there is over 20chars long
now anyway so I will have to do a little bit of hand massaging.
Phil.
Rohit Gupta wrote:
Thats the way it is. You get around it by creating a new field, copy
the data, delete the old one
Phil Middlemiss wrote:
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
_______________________________________________
Delphi mailing list
[email protected]
http://ns3.123.co.nz/mailman/listinfo/delphi
begin:vcard
fn:Phil Middlemiss
n:Middlemiss;Phil
org:Vision Software, MTS Ltd
email;internet:[EMAIL PROTECTED]
title:Project Leader
tel;work:+64 7 3480001
tel;cell:+64 27 4592648
x-mozilla-html:TRUE
url:http://www.tumonz.co.nz
version:2.1
end:vcard
_______________________________________________
Delphi mailing list
[email protected]
http://ns3.123.co.nz/mailman/listinfo/delphi
