Mx.ODBC insert error

[Greg Corradini]

Hello,
I've never gotten this traceback error before using mx.ODBC. Any ideas about
resolving this issue? The statement and the error it generates are listed
below.

curse.execute("Insert into FHWA_StandSamp_2008(LRS_ID_NEW)
values('0402000010') where LRS_ID = '0403700010'")

Traceback (most recent call last):
File "<pyshell#37>", line 1, in ?
  curse.execute("Insert into FHWA_StandSamp_2008(LRS_ID_NEW) values
('0402000010') where LRS_ID = '0403700010'")
ProgrammingError: ('37000', -3516, '[Microsoft][ODBC Microsoft Access
Driver] Missing semicolon (;) at end of SQL statement.', 4612)

Thanks
Greg

-- 
View this message in context: http://www.nabble.com/Mx.ODBC-insert-error-tp15163149p15163149.html
Sent from the Python - python-list mailing list archive at Nabble.com.