f



SQLExecute Update to MS-ACCESS text field

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



0
me8019 (1)
12/14/2008 12:33:45 PM
comp.soft-sys.math.mathematica 28821 articles. 0 followers. Follow

0 Replies
321 Views

Similar Articles

[PageSpeed] 28

Reply: