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