Looking to add a column to an existing ElevateDB table at runtime through program code

On 10/19/2015 1:17 PM, Max Stewart wrote:
> Looking to add a column to an existing ElevateDB table at runtime through program code

Again - i would suggest you look at the manual:

http://www.elevatesoft.com/manual?action=viewtopic&id=edb2sql&topic=ALTER_TABLE

Raul

Max,

<< Looking to add a column to an existing ElevateDB table at runtime through program code >>

Raul is, again, correct with the link.  Unlike DBISAM, EDB executes all data-definition operations via SQL.

Tim Young
Elevate Software
www.elevatesoft.com

Max

If you are working within a Delphi programme you may have EDB database and table components open.

Remember first, you can't ALTER a table unless there are no other users (including yourself) accessing it, as the DB requires a full lock of the table prior to any ALTER statement.

Once you have this you can pass ALTER statements to an EDBQuery component's "SQL.Text" property and they will work:

ALTER TABLE <name>
ADD COLUMN <name> VARCHAR(50)

It has been a long time since I did it this way, but I am pretty sure it works.

You may do well to look search for "tutorials alter table SQL" in Google ... as it is a complex area.

Max


And finally since no one else has mentioned it - when you have a problem of this nature do it in EDBManager and then look in Explorer | SQL History and you will see the sql command you need to use.

This is very very useful since it effectively shows you all of the structure management commands on your tables

Roy Lambert