Someone can help me please

[RavensFan]

He is saying to add another loop around the code you already have!

[Jxwong2203]

Thanks Raven ! i will gv it a try. Appreciate it 😃

[Jxwong2203]

Thanks raven, i solved the problem already !

[Jxwong2203]

Beside insert the wind speed data collected into text file, i have to insert the data into mysql database too, can i do it with my current vi file ?
DSN server is set and database connection is ok. but it show some error once i start my program, the i attached some pic of my programs, error, and table to insert into mySQL.

Can i have any suggestion on what have to correct in order to get it work ? Really appreciate it !

This is the data log into text file. i wanna do the same to mySQL. logging data to both places.

This the error pop out when i run the program.

This is my program, is there any problem with the 2nd concatenate string's connection which connect to ADO SQL execute ?

This is where i wanna insert the data into mySQL, 3 columns with header inserted, Date with format "DateTime" Time with format "TimeStamp"  Wind Speed with the format "Decimal(10,10).

Hope i can get some ideas from u all. !!

[dkfire]

You need to make a proper SQL query for this to work. You have completely missed how a SQL should be formatted.

Instead of the value1, value2 and value3 you need to have your real data there.

One note, as this new question is a different problem you should have started a new thread.

[Jxwong2203]

thanks for your reply dkfire, what do u means by real data for value1,value2,value3 ?

i did some reseach on website, they show some example here.

INSERT INTO CUSTOMERS (ID,NAME,AGE,ADDRESS,SALARY)
VALUES (1, 'Ramesh', 32, 'Ahmedabad', 2000.00 );

but the problem is the values to insert is the value we get from programs right ? y they know what values to put to into tables. Im blur with it.

so i follow the format teach by tis web. http://www.tutorialspoint.com/sql/sql-insert-query.htm

INSERT INTO TABLE_NAME (column1, column2, column3,...columnN)] 
VALUES (value1, value2, value3,...valueN);

[dkfire]

You need to format the SQL query with your data.

You know the data, and I have told you where to place the data in the query.

Spoiler

[Jxwong2203]

Dear dkfire, ok noted. Thanks for sharing !