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

Reply via email to