sql - What is wrong with this SQLite query? -


I am creating an AIR application that connects to a SQLite database, this means the database in the insert statement, and I I can not understand why there is no error, it just does not let it move forward.

  INSERT INTO participants (AttendeeId, ShowCode, last name, first name, company, address, address 2, city, state, zip code, country, phone, value ('39610', '111111 ',' SMIT ', fax, email, buy, primary business, business, employee, job, value, quantity, spouse business, date, construction work type, userpress, decismaker, secure, passbooks purchase, rip contact, winner) ',' Company ',' 1000 Street Street ',' ',' Pittsburgh ',' W A ',' 15219 ',' ',' +5555555555 ',' +5555555555 ',' PERSON@EXAMPLE.NET ',' ',' ',' 0000000000000000000 ',' ',' ',' ',' ' '0?', 'Venus 30 January 14:20:08 GMT-0500 200', 'other', 'no', 'no', 'no', 'no', 'winner')  / Pre> 

I know that the app can be connected to the database, because it just makes the table just fine Here is the schema for the table for your reference:

  (AttendeeId Text Primary key, showcode text, last name text, first lesson, company text, address text, address 2 text, city text table participant Read, Text, Text, Text Text, Text Text, Text Text, Text Text, Text Text, Text Text, Text Text, Text Text, Text Text, Text Text, Text Text, UserPurchaser Lesson, DecisionMaker Text, SafetyProducts Lesson, NearFuturePurchase Text, RepContact Text, Winner Lesson) There is a good chance there is no error in the insert statement, because if I want to execute it Have a different Adobe Air SQLite admission program, it's a vague Throws error (# 3115).  

Thanks for any information.

Edit:

They think, if I make a simple table, then:

  Make table appearance (present text)  / Code>  

and try to insert, as follows:

  The participant (AttendeeId) values ​​('09283A') in INSERT  

I still get error # 3115.

postprop = "itemprop = attendee (" presence id "," shocked "," lastname "," firstname "," company "," address "," address 2 "," City "," State "," Lesson "," Zip Code "," Country "," Phone "," Fax "," Email "," Buy "," Primary Business "," Business "," Employee "," Company "," 1000 Road Street "," "," Job "," Value "," Volume "," Life Partner Business Values ​​('39610', '111111', 'Smith', 'GIM') 'Pittsburgh', 'PA', '15219', '', '5555555555', '5555555555', 'Parsonexample.net', '', '', '0000000000000000000', '', '', '', ',' 0 '', 'Fri 30 Jan Ri 14:20:08 GMT-0500 200 9, 'other', 'no', 'no', 'gas_datuction', 'no', 'no', 'winner');

Try it, this computer was generated.


Comments