Hi.
If this is the wrong forum i apologize..
inserting a Float value to sql...
I Got an Error in my scada system (indusoft, VBscripting)
I got the Error: Error to convert varchar to float. ive been reading alot of solution since its not?? possible to insert a float into sql, but none of them fits the syntax of VBscripting..
here is my insert script:
Dim sql
sql = "INSERT IGNORE INTO Table_1 VALUES(" & $TEST_C1_A & "," & $TEST_C2_A & ",'" & $TEST_C3_A & "','" & $TEST_C4_A & "','" & $TEST_C5_A & " Km/t" & "','" & $TEST_C6_A & "')"
$DBExecute("DB", sql,"",1000000000,"Status")
$reload = $reload+1
this tag ($TEST_C5_A) is a float how to convert it
If this is the wrong forum i apologize..
inserting a Float value to sql...
I Got an Error in my scada system (indusoft, VBscripting)
I got the Error: Error to convert varchar to float. ive been reading alot of solution since its not?? possible to insert a float into sql, but none of them fits the syntax of VBscripting..
here is my insert script:
Dim sql
sql = "INSERT IGNORE INTO Table_1 VALUES(" & $TEST_C1_A & "," & $TEST_C2_A & ",'" & $TEST_C3_A & "','" & $TEST_C4_A & "','" & $TEST_C5_A & " Km/t" & "','" & $TEST_C6_A & "')"
$DBExecute("DB", sql,"",1000000000,"Status")
$reload = $reload+1
this tag ($TEST_C5_A) is a float how to convert it