Running data continuously in a database

[Dennis_Knutson]

That's just wrong as I guessed. You need to understand basic dataflow. Take some of free tutorials and then modify your program per either of my previous suggestions. As it is, you are passing a single value of each to the database loop and just writing the same over and over again.

[narlun2010]

Hello thanks for your comment and i will do as you suggested, also the data will be about the same for each as it is being sampled as in the picture i have attached. I expect the numbers to look like that in the database.

[Dennis_Knutson]

And you did not create a snippet as I asked. When you are done with the tutorials, read the help and try again.

[muscles05]

Yes thanks and as my friend mentioned above the values will be the same and should look like this. I will watch the videos

[Yamaeda]

_About_ the same isn't the same as _Repeated_. From the picture you'll send the last read value to be written several times in the database, that's probably not what you planned. Dataflow. 😉

SQL Express is a good suggestion mentioned earlier, the small differences between Access and MS SQL syntax wont bite you that way.

I assume you want DB Insert, not Update, you dont want to overwrite old values, do you? If you only want the last run in the table you can do a Delete * from [table] before inserting.

As suggested, make a small test vi which only writes some constants to the database to make sure that part is working first.

/Y

[muscles05]

hey dennis thanks for your help i was able to successfully get the data to mysql database, you can see how i set up my code using code snippet as you asked. I also had one more question how would i send values back to my microcontroller to display on the lcd of my microcontroller, is there some special visa i need to use or what, as you see i want to send the frequncy and rms voltage back to the lcd on my micro.

[Dennis_Knutson]

That is entirely up to the code on the micro. There is no such thing as a special VISA. You would use a VISA Write and send a string that has the format that the micro expects.

[narlun2010]

yes i get that but to send the frequency, voltage and so on, i know i would need to convert to string but to send each to display on lcd would i use a cluster again or how would i tie each to the visa write. and the visa write would be located outside consumer look correct???

[muscles05]

thanks for asking my comment steven lol

[muscles05]

anyways dennis

i get it up to the micro code and i know i would need to convert to string but how would i send the data to the visa write, so the micro can display freq. and voltage. like how would i wire the two differnt reading for the lcd to the visa write. and would visa write be outside consumer loop.