Re: Understanding mxODBC Insert Error

2007-07-29 Thread Jon Clements
call last): > File "", line 1, in ? > crs.execute(sql) > ProgrammingError: ('37000', -3516, '[Microsoft][ODBC Microsoft Access > Driver] Missing semicolon (;) at end of SQL statement.', 4612) > > -- > View this message in > context:http://ww

Re: Understanding mxODBC Insert Error

2007-07-29 Thread John Machin
On Jul 30, 2:41 am, Greg Corradini <[EMAIL PROTECTED]> wrote: > Hello, > I'm trying to perform a simple insert statement into a table called > Parcel_Test (see code below). Yet, I get an error message that I've never > seen before (see traceback below). I've tried to put a semicolon at the end > of

Re: Understanding mxODBC Insert Error

2007-07-29 Thread Harrie Geerts
>> crs.execute(sql) > > TRACEBACK > Traceback (most recent call last): > File "", line 1, in ? >crs.execute(sql) > ProgrammingError: ('37000', -3516, '[Microsoft][ODBC Microsoft Access > Driver] Missing semicolon (;) at end of SQL statement.'

Understanding mxODBC Insert Error

2007-07-29 Thread Greg Corradini
','0.00') where PIN_ID = '042822120008'" >>> crs.execute(sql) TRACEBACK Traceback (most recent call last): File "", line 1, in ? crs.execute(sql) ProgrammingError: ('37000', -3516, '[Microsoft][ODBC Microsoft Access Drive