fetching and updating data from database

[skyIsNotLimit]

Hey

I'm new to labview. I'm trying  some database exercises, in that i want to create a database and show it on the table below also Update and fetch the data from it. for fetching the data : when i click on any cell of the table ,the entire row value should fetched in the given entries. and for updating the data: i need to click on update button to update the entries in the particular cell of the table.Also as i create new entry the Sr. no column should be increment.

i'm done something but not getting appropriate result.i'm only able to fetch first row data and with update section i'm getting error. if anyone can help me in that.

here my attached file both front panel and block diagram.

[Rahulbala]

Hello

I haven't seen the logical flow of your VI completely. But for easily fetching, you can use multicolumn listbox and change selection mode to Highlight entire row and use property node "Strings[]" to update and read the listbox.

Will get back to you with something else. Hope this helps

-Rahul

Hit KUDOS for Thanks

[skyIsNotLimit]

thanks for reply but i'm still not able to fetch data on clicking on particular cell of a row. 

[skyIsNotLimit]

Okay I'm done with fetching the data ...but still left with updating the selected row. How can i do this part please let me know. i have attached my VI here.

[Rahulbala]

Hello

Good work for completing the fetching part. While using DB Tools Update.vi to update, it is not required to flatten the cluster(set the boolean to false) and try updating the multicolumn listbox (from the DB) after the DB update operation.

-Rahul

Hit KUDOS for Thanks

[skyIsNotLimit]

Hey

I'm not using cluster, my input entries are simple strings. I have to update a selected row which i'm still not able to do. I'm getting error "Object 0x000000 is not valid." every time .....please help me

my vi is attached above.

[skyIsNotLimit]

i'm not getting any solution. please help me out. I'm getting same error every time. I'm frustrated now.Is there any difference of using connection string and UDL. In my case i'm using connection string as a path to open database, i cannot use udl as per my task. please help to find solution 

[skyIsNotLimit · Accepted solution]

I have completed my first task on database. Still there are lots of things to learn.Hoping i will get best support from this forum.

Here is my solved VI, If anyone want to refer.

[Frozen]

Are you open to a little constructive criticism?

Your code is well organized, but could use a bit more tidying-up...

Also, you are using a shift register (in the above picture) but you are constantly over writing it. Plus, you never actually use it for anything else.

You should also probably make a sub-vi out of your quick-n-dirty 2D sort since it is used in multiple states.

Hope this helps 🙂

[skyIsNotLimit]

Definitely, i'm open to all sort of constructive criticism of my code as they build my learning.

I'm a learner and wants to improve.I really appreciate you taking the time to talk about the things that haven't cross my mind.I surely see to it and improvise.

Thank you.