I defined a table in excel in a sheet named 'User' as follows:
EmpID Password Status
A1 A1 Active
A2 A2 ShortLeave
A3 A3 LongLeave
A4 A4 Inactive
B1 B1 Dormant
I executed an update sql which returned a syntax error.
Question: What is the right syntax to use?
SQL: "Update User set {v'Status'} = 'Sleeping Soundly' where {v'EmpID'} = 'B1' " ;
Error:
java.sql.SQLException: Syntax error: Stopped parse at .
at com.hxtt.global.SQLState.SQLException(Unknown Source)
at com.hxtt.a.b.a(Unknown Source)
at com.hxtt.a.b.a(Unknown Source)
at com.hxtt.a.b.g(Unknown Source)
at com.hxtt.sql.bm.o(Unknown Source)
at com.hxtt.sql.ag.if(Unknown Source)
at com.hxtt.sql.ag.a(Unknown Source)
at com.hxtt.sql.ag.a(Unknown Source)
at com.hxtt.sql.ag.executeUpdate(Unknown Source)
at pocs.msexcel.Test.main(Test.java:87)
|
You can try
Update User set "Status" = 'Sleeping Soundly' where "EmpID" = 'B1' ;
|
Main
webmaster@hxtt.com