combo box

[Soundarya]

hi,

I have added items to a combo box.

how can i send those items to the database(ms-access)?

tell me how to do this in labview?

InAdvance Thanks

Regards

Soundarya

[Christian Mergl]

You can use the Database and Connectivity Toolkit!

[muks]

How many threads are you going to create . Please continue here

[Soundarya]

hi, I have some list of values in the database like:ate,hal,shop and qc.

so i want to update the field value in the database for example "from ate to ni"

i have written an update statement, but all the values are getting updated. i want to update only one field when i click a particular value in a combo box

can u tell me how to write the sql statement for this?

InAdvance Thanks

Regards

Soundarya

[parthabe]

---

Soundarya wrote:

can u tell me how to write the sql statement for this?

---

You must post this to SQL forums?

[MikeS81]

Hi Soundarya,

can you show what you have done so far? Maybe you can also upload a part of your database.

Did you make a search for "update"?

Mike

[Soundarya]

hi,

i will explain u what I want exactly.

i have a combo box in my vi. in that i have added items like:shop,qc,qae and sqae.

so i want to update that shop, qc,qae and sqae. and i have all these values in my ms-access too.

i have used db connectivity tool for updating, but it is updating each value.

but my requirement is: whenever i click a particular value in a combox box, only that value has to get updated. how can i do this in labview?

Regards

Soundarya

[MikeS81]

Hi Soundarya,

you can use an event structure. In the value change event of your combo box, you can read the selected value and build your update query.

It should be something like this:

UPDATE table SET columnname='new' WHERE columnComboBox='selectedValue'

Mike

[Soundarya]

hi,

i have done the samething as u said before itself.

but my doubt is what is that selected value u have mentioned. i mean how do u get that?

InAdvance Thanks

Regards

Soundarya

[MikeS81]

Hi Soundarya,

please see the attached picture.

Mike