To archive data/values from WinCC RT into SQL database, is it correct to use this command below?
SQL_Table = "INSERT INTO " & szTableName & " (SPEED, TEMPERATURE, ERROR)" _
& "VALUES (" & Speed & ", " & Temp & ", ' " & szError & " ' )"
SPEED,TEMPERATURE, and ERROR are the colums name.
Speed,Temp and szError are the tags. szError is string type and the other two are decimal.
I put this command just after CREATE TABLE commands..the table is created but i got an error "Incorrect syntax near ',' "
Could you help me, please? Thank you in advance