Arggghhh, sorry, I said db file but what I really meant was dbF file.
This is probably why it wont work. I have since created a new table, batch
moved the record and deleted/renamed. This works fine, but it probably
slower.
Cheers
"Max Renshaw-Fox" <[EMAIL PROTECTED]> on 25/02/99 11:16:27
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
I'm using BDE 5.01 and just tested on a Paradox table created using a
statement copied direct from localsql.hlp in the BDE directory...
CREATE TABLE "Shared.db"
(
last_name CHAR(20),
first_name CHAR(15),
salary NUMERIC(10,2),
dept_no SMALLINT,
PRIMARY KEY (last_name, first_name)
)
I then added another field CHAR(25)...
ALTER TABLE "Shared.db" ADD AField VarChar(25)
Then tested VarChar just for interest...
ALTER TABLE "Shared.db" ADD NewField VarChar(25)
I have also found that a "Capability Not Supported" messages seem to be
followed by other things I know-to-work giving the same message until the
BDE is unloaded and reloaded - I've never bothered to check it
systematically so can't guarantee this.
But it definitely works on .db = Paradox with latest BDE.
Max
Oh, this didn't work - 'Capability not supported'.
Got any other ideas?
---------------------------------------------------------------------------
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
