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
RE: [DUG]: Adding a new column to a db file
If it's a dBase or Paradox table, you can use a DBI call like DBIDoRestructure -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of [EMAIL PROTECTED] Sent: Wednesday, 24 February 1999 16:53 To: Multiple recipients of list delphi Subject: RE: [DUG]: Adding a new column to a db file 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
RE: [DUG]: Adding a new column to a db file
DbiDoRestructure is not for the faint of heart (that's why they wrote TUtility.dll). It's a bit of a guessing game how the structures need to be filled - there are now more examples on borland.com but it's still a beast. However the same job can be done with TUtility (or TTUtility) and "repairing" from a template Max -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Patrick Dunford Sent: Thursday, 25 February 1999 12:51 To: Multiple recipients of list delphi Subject: RE: [DUG]: Adding a new column to a db file If it's a dBase or Paradox table, you can use a DBI call like DBIDoRestructure -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of [EMAIL PROTECTED] Sent: Wednesday, 24 February 1999 16:53 To: Multiple recipients of list delphi Subject: RE: [DUG]: Adding a new column to a db file 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
RE: [DUG]: Adding a new column to a db file
The problem with TUtility is that it is Paradox only. If i read right this guy wants to restructure a dBase table. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Max Renshaw-Fox Sent: Thursday, 25 February 1999 12:59 To: Multiple recipients of list delphi Subject: RE: [DUG]: Adding a new column to a db file DbiDoRestructure is not for the faint of heart (that's why they wrote TUtility.dll). It's a bit of a guessing game how the structures need to be filled - there are now more examples on borland.com but it's still a beast. However the same job can be done with TUtility (or TTUtility) and "repairing" from a template Patrick Dunford, ChristChurch, NZ http://patrick.dunford.com/ --- New Zealand Delphi Users group - Delphi List - [EMAIL PROTECTED] Website: http://www.delphi.org.nz
RE: [DUG]: Adding a new column to a db file
Agreed - he is using dbf, The point is that DbiDoRestructure is complex - Local SQL WILL add columns to DBase tables. Max -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Patrick Dunford Sent: Thursday, 25 February 1999 13:07 To: Multiple recipients of list delphi Subject: RE: [DUG]: Adding a new column to a db file The problem with TUtility is that it is Paradox only. If i read right this guy wants to restructure a dBase table. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Max Renshaw-Fox Sent: Thursday, 25 February 1999 12:59 To: Multiple recipients of list delphi Subject: RE: [DUG]: Adding a new column to a db file DbiDoRestructure is not for the faint of heart (that's why they wrote TUtility.dll). It's a bit of a guessing game how the structures need to be filled - there are now more examples on borland.com but it's still a beast. However the same job can be done with TUtility (or TTUtility) and "repairing" from a template Patrick Dunford, ChristChurch, NZ http://patrick.dunford.com/ --- 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