Mark
Depending on what kind of DB you're using, e.g. in Informix you can do this:
alter MyTable
modify MyField varchar(64);
Assuming that you are actually increasing the field length you will not
loose any data.
I suggest you try this with a same table first.
Martin.
> -----Original Message-----
> From: [EMAIL PROTECTED]
> [mailto:[EMAIL PROTECTED]]On Behalf Of Mark Derricutt
> Sent: Tuesday, 10 August 1999 17:02
> To: Multiple recipients of list database
> Subject: [DUG-DB]: ALTER queries
>
>
> Hiya, when using ALTER TABLE style queries, from the help I
> see you can
> DROP and ADD fields, can I just change a field?
>
> Say I've got a string thats 32 chars long and I now want it 64 long,
> keeping the data thats there, can I do that with an ALTER TABLE query?
>
>
>
>
>
> ALTER TABLE "employee.dbf" DROP LAST_NAME, DROP FIRST_NAME,
> ADD FULL_NAME
> CHAR[30]
>
> --
> Mark Derricutt, PB Power NZ Ltd (http://www.pbpower.net)
> Getting jiggy with Skid Row - My Enemy - Winamp
>
> --------------------------------------------------------------
> -------------
> New Zealand Delphi Users group - Database List -
> [EMAIL PROTECTED]
> Website: http://www.delphi.org.nz
>
>
---------------------------------------------------------------------------
New Zealand Delphi Users group - Database List - [EMAIL PROTECTED]
Website: http://www.delphi.org.nz
---------------------------------------------------------------------------
New Zealand Delphi Users group - Database List - [EMAIL PROTECTED]
Website: http://www.delphi.org.nz
