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. -- http://mail.python.org/mailman/listinfo/python-list