SQLExecute Update to MS-ACCESS text field
- To: mathgroup at smc.vnet.net
- Subject: [mg94447] SQLExecute Update to MS-ACCESS text field
- From: me at goals.com
- Date: Sun, 14 Dec 2008 07:33:52 -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'.