RE: [DUG]: Adding a new column to a db file

1999-02-24 Thread Max Renshaw-Fox
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 Re

RE: [DUG]: Adding a new column to a db file

1999-02-24 Thread Patrick Dunford
e 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

RE: [DUG]: Adding a new column to a db file

1999-02-24 Thread Max Renshaw-Fox
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&#

RE: [DUG]: Adding a new column to a db file

1999-02-24 Thread Patrick Dunford
> 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 -

RE: [DUG]: Adding a new column to a db file

1999-02-24 Thread pjones
; 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.

RE: [DUG]: Adding a new column to a db file

1999-02-24 Thread Peter Harrison IT
EMAIL PROTECTED]] Sent: Thursday, February 25, 1999 12:16 PM To: Multiple recipients of list delphi 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... CR

RE: [DUG]: Adding a new column to a db file

1999-02-24 Thread Max Renshaw-Fox
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 th

RE: [DUG]: Adding a new column to a db file

1999-02-24 Thread pjones
cc: 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

RE: [DUG]: Adding a new column to a db file

1999-02-23 Thread Max Renshaw-Fox
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

[DUG]: Adding a new column to a db file

1999-02-22 Thread pjones
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 Li