jeudi 27 août 2015

SQLiteException syntax error for some devices? [duplicate]

This question already has an answer here:

My sqlite query works great for all devices that i have tested, but for one old android 4.0.4 device it causes android.database.sqlite.SQLiteException: near ",".

INSERT INTO TAB_QUEST_REWARD ( _id,b_str,b_speed,b_rep,b_money,b_item_id,b_food,b_alco,b_hp,b_act) VALUES('rew284',0,0,0,0,0,0,0,0,0),('rew285',0,0,0,0,0,0,0,0,0),('rew286',0,0,0,0,0,0,0,0,0), ('rew287',0,0,0,0,76,0,0,0,0),('rew288',0,0,0,0,0,0,0,0,0),('rew289',0,0,0,0,0,0,0,0,0),('rew290',0,0,0,0,0,0,0,0,0), ('rew291',0,0,0,0,0,0,0,0,0),('rew292',0,0,0,0,0,0,0,0,0),('rew293',0,0,0,0,0,0,0,0,0),('rew294',0,0,0,0,0,0,0,0,0), ('rew295',0,0,80,280,0,0,0,0,0),('rew296',0,0,0,0,0,0,0,0,0),('rew297',0,0,0,0,0,0,0,0,0),('rew298',0,0,0,0,0,0,0,0,0), ('rew299',0,0,0,0,0,0,0,0,0),('rew300',0,0,0,0,0,0,0,0,0),('rew301',0,0,20,0,0,0,0,0,0),('rew302',0,0,0,0,0,0,0,0,0), ('rew303',0,0,0,0,0,0,0,0,0),('rew304',0,0,0,0,0,0,0,0,0),('rew305',0,0,200,1000,0,0,0,0,0),('rew306',0,0,0,0,0,0,0,0,0);

What is wrong here?

Aucun commentaire:

Enregistrer un commentaire