Re: [sqlite] operational errors on insert with Python

2005-06-23 Thread Hugh Gibson
> The error returned is OperationalError: near ".", syntax error. Probably because you need to enclose the version strings in single quotes. > OperationalError: no such column: finally Use single quotes around values in the SQL. Contents of double quotes are interpreted as field names. Hugh

[sqlite] operational errors on insert with Python

2005-06-23 Thread Greg_Miller
I have a Python/wxPython application that inserts data in many places into various tables in a sqlite database. All the inserts work fine except for the latest one: autoStartcursor.execute('INSERT INTO baseappstart (SerialNumber, Time, FUSoftwareVersion, GUISoftwareVersion, NexpertVersion,