Edit a particular element in a data base table

[karpaga]

I can use the check if file exist for database also.

[MikeS81]

Hi kavi,

it's a file on your harddisk, so you can use the normal file functions. In this case "Check if file or folder exists.vi" should work for you.

Mike

[karpaga]

The solution u gave for uptate is suitable if im havings data set set with less than no of columns.

I want to replace a row dataset with 50 columns there is any simply way?

[karpaga]

The solution u gave for uptate is suitable if im havings data set set with less no of columns.

I want to replace or update a row dataset with 50 columns there is any simply way?

[karpaga]

is my question is clear for u?

[MikeS81]

Hi kavi,

you can use the update command for it. It should work for as much columns as you need.

You can write your own function to build the UPDATE command.

See the attached image as an idea.

Mike

[karpaga]

anybody?

[Dennis_Knutson]

Start reading the answers given and find a tutorial on SQL. It does not matter how many columns you have - 1 or a million. The Update command works the same way

[karpaga]

k dennis

[karpaga]

Hi 

I create mdb file using create mdb vi.

But i link that mdb to the ODBC manually 

    i click the administrative tools in the control panel.Click Data sources ODBC and click system dns tab.

   click add and select microsoft access driver for mdb

   In the ODBC data setup screen i entered the data source name as sample and click select and select the      mdb from the path it created already.and click ok.

is it possible to link mdb to ODBC programatically through labview as like mbd creation?