MathGroup Archive 2008

[Date Index] [Thread Index] [Author Index]

Search the Archive

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'.



  • Prev by Date: Re: spatial coherence
  • Next by Date: LayeredGraphPlot
  • Previous by thread: LocatorCentering & BoxForm`ClickRadius
  • Next by thread: LayeredGraphPlot