need help for "From concatenate string insert to mysql table"

[Jxwong2203]

Hi mr Mike, the A,B,C just a testing only. Now i have change to as pic below.

Thanks to teaching me to connect like tis. It works well. !!

I got a question. Can i extract out the highest value in  wind speed column in mysql and show it on my front panel in labview ? 

[Dennis_Knutson]

Yes, it's quite easy with the SELECT statement. Google is your friend. Simply search for SQL SELECT MAX. A basic SQL tutorial would be of great benefit to you.

[Jxwong2203]

okay noted. Thanks denniss ! 

[jcarmody]

Now that things are starting to work for you, it's time to get the database Open and Close out of your While loop.  There's no reason to create/open/close the connection every time through the loop, is there?

[Jxwong2203]

Jim, if i remove ADO Open connection, The DSN=Nyp; link will dissapear, will it lose connection to mysql database ? 
Now i added one more to show the Highest wind speed logged. And the connection is as pic below. Can i remove the ADO Open , and Close for both ? 

[jcarmody]

---

@Jxwong2203 wrote:

Jim, if i remove ADO Open connection, The DSN=Nyp; link will dissapear, will it lose connection to mysql database ? 
Now i added one more to show the Highest wind speed logged. And the connection is as pic below. Can i remove the ADO Open , and Close for both ? 

---

I didn't mean to remove it, just move it outside of your While loop so you're not creating/opening/closing it every time through the loop.  Here's what I meant:

[Jxwong2203]

Ok jim, noted ! thanks for your suggestions 😄