Mx.ODBC insert error

Greg Corradini gregcorradini at gmail.com
Tue Jan 29 17:27:13 CET 2008


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.




More information about the Python-list mailing list