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, OSISVersion, SDMSVersion, Login) VALUES ('+serialNum+', '+timetemp+', '+fusBuildVer+', '+guiVerTemp+', '+nexpertVersion+', '+osisverData+', '+sdmsver+', '+accessLvl+')') I have printed out a test string which returns this: test string is INSERT INTO baseappstart (SerialNumber, Time, FUSoftwareVersion, GUISoftwareVersion, NexpertVersion, OSISVersion, SDMSVersion, Login) VALUES (1, 1119528625, unknown, 2.5.6, 02.05, 2.5.4, 1.0.0.1, Operator) as far as I can tell the syntax is correct, when I manually insert it using Sqlite Analyzer it works fine too. The error returned is OperationalError: near ".", syntax error. When I cut this down to just sending this: autoStartcursor.execute("INSERT INTO baseappstart (SerialNumber) VALUES ("+test+")"), with test == 'finally', I get the following error: OperationalError: no such column: finally I've reached the end of what I can figure out about this, anyone have any thoughts, or seen this before?? ______________________________________________________________________ IMPORTANT NOTICE: The information in this email is confidential and proprietary to NexPress Solutions, Inc. and may be legally privileged. It is for the intended recipient(s) named above only. Any unauthorized review, printing, copying, use or distribution of this email by anyone else is prohibited and may be a criminal offense. If you have received this email in error, please notify the sender immediately by reply email and delete the original message.