Update Access Database with Labview

[jdebuhr]

I have done some searching on the forum and found a couple previous topics to help, but I have a few more questions. This is my first time actually using databases, so I am somewhat of a newbie when using them with LabVIEW.

Basically I want to be able to update values in a database. I know I could just delete and recreate the Table but if I can update values it may be a bit better.

I found that the only way to update is to use the SQL commands as the dBASE Tookit does not have an Update VI. so do I need to have the WHERE command int he Update command when I send it? I would want to update the whole column that is cuirrently present.

Also is there a way to Add a new column in a database VIA labview without deleting and recreating the table?

[Dennis_Knutson]

I don't use the toolkit so I can't address the Update function there but if you use the SQL UPDATE command, the WHERE clause is optional. If you want to change every row to a certain value then it's UPDATE table_name SET column_name = expr.

I don't believe that SQL itself has a command to add a new column. The database you're using might have a method for doing it though. I know SQL Server does. You might be able to write a stored procedure to do this if you really need to.