In short no. I would do the following.
1 - Create A new Field that is the length you want (but with a name like
tempField).
2 - Copy the data from old field into new field.
3 -Drop original field.
4 - Recreate the original field with the correct length.
5 - Copy date form temp field into the expanded original.
6 - drop temp field.
This assumes that:
i) you have to preserve the filed name.
ii)This is not a primary or foreign key field.
Nigel.
> -----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
