Thanks John. I now see it John Machin wrote: > > On Jan 30, 3:27 am, Greg Corradini <[EMAIL PROTECTED]> wrote: >> Hello, >> I've never gotten this traceback error before using mx.ODBC. > > "traceback error"?? I see no problem with the traceback. > >> Any ideas about >> resolving this issue? The statement and the error it generates are listed >> below. > > The error was "generated" by you. The error message was generated by > "[Microsoft][ODBC Microsoft Access Driver]" > >> >> 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) >> > > Like it says, ProgrammingError. > > Try > INSERT INTO table (columns) VALUES (values) > or > INSERT INTO table (columns) > SELECT stuff FROM somewhere [WHERE boolean_expression] .... > or perhaps even > UPDATE table SET column = expression WHERE boolean_expression > > Perhaps you could consider avoiding combining random fragments of SQL > or English and hoping for tolerant fuzzy parsing by the recipient :-) > > HTH, > John > -- > http://mail.python.org/mailman/listinfo/python-list > >
-- View this message in context: http://www.nabble.com/Mx.ODBC-insert-error-tp15163149p15166795.html Sent from the Python - python-list mailing list archive at Nabble.com. -- http://mail.python.org/mailman/listinfo/python-list