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
