Oh, this didn't work - 'Capability not supported'.
Got any other ideas?
"Max Renshaw-Fox" <[EMAIL PROTECTED]> on 23/02/99 20:31:30
Please respond to [EMAIL PROTECTED]
To: Multiple recipients of list delphi <[EMAIL PROTECTED]>
cc: (bcc: Peter Jones/Logistics&Information
Technology/Christchurch/Foodstuffs)
Subject: RE: [DUG]: Adding a new column to a db file
You can use local SQL to actually add the column - if there are no
constraints etc
"ALTER TABLE "Shared.db" ADD NewField VarChar[25]"
I would tend to look for the field and put the add field code in an except
block. Since
it's a shared file you're probably opening it anyway.
Max
-----Original Message-----
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On
Behalf Of [EMAIL PROTECTED]
Sent: Tuesday, 23 February 1999 16:52
To: Multiple recipients of list delphi
Subject: [DUG]: Adding a new column to a db file
I have a program that reads from a shared db file. I need to add a new
column to the table if it is not already in it. Does anyone have a small
sample of how to do this?
---------------------------------------------------------------------------
New Zealand Delphi Users group - Delphi List - [EMAIL PROTECTED]
Website: http://www.delphi.org.nz
---------------------------------------------------------------------------
New Zealand Delphi Users group - Delphi List - [EMAIL PROTECTED]
Website: http://www.delphi.org.nz
---------------------------------------------------------------------------
New Zealand Delphi Users group - Delphi List - [EMAIL PROTECTED]
Website: http://www.delphi.org.nz