SQLExecute update of an Access file and getting ODBC error
- To: mathgroup at smc.vnet.net
- Subject: [mg94600] SQLExecute update of an Access file and getting ODBC error
- From: mathman at none.com
- Date: Wed, 17 Dec 2008 06:33:53 -0500 (EST)
I'm trying to update an access .mdb table1 field test, a text field and am getting the resulting error below. Any ideas. TIA In v8=16 v11=5 v13= ToString[v8]<>"-"<>ToString[v11]; SQLExecute[db,"UPDATE table1 SET test = "<>v13<>" WHERE rec = "<>ToString[recV]]; Out JDBC::error: [Microsoft][ODBC Microsoft Access Driver] Syntax error (missing operator) in query expression '16-5'.