I assume you're using .dbf files - in which case you can use database
desktop or dbiDoRestructure which is probably more difficult than using SQL
to create a new field and move the data across (unless a foreign key is
involved).
Max
-----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
