Mx.ODBC insert error

Greg Corradini gregcorradini at gmail.com
Tue Jan 29 20:07:34 CET 2008


Thanks John. I now see it 

John Machin wrote:
> 
> On Jan 30, 3:27 am, Greg Corradini <gregcorrad... at gmail.com> 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.




More information about the Python-list mailing list