adding NEW columns (fieldnames) to and access database

[mda711]

How can I add a new column (fieldname) to an existing database using Labview.  I can currently read and write to the db but I need to programmatically add a column.

[mikeporter]

You need to execute an ALTER TABLE statement something like:

ALTER TABLE my_table
ADD  my_new_column  INTEGER

This statement will add a new column called "my_new_column" containing integer data to the table "my_table".
And you can also add constraints such as NOT NULL if desired. However your ability to execute this statement from LV 
will be dependent upon the permissions that have been granted to your account has been granted.

Mike..

[Nathan Vaidyanathan]

Mike,

I have a similar requirement. Could you please post an example VI to add new columns programmatically.

[jareds]

Hi Sarasvisu,

I believe it should look something like this:

 

This would add a column called newField of type Text into the myNewTestTable table.  As Mike noted, you will need permissions to modify the database though. 

[Nathan Vaidyanathan]

Thanks. Much Appreciated.