On 2016/02/09 1:30 PM, Chris Prakoso wrote: > Hi Clemens, > > Thanks for your reply. I've tried to use raw SQL but it didn't work > either. Do you have any SQLite front-end that you use?
If I may suggest, try SQLitespeed (http://sqlc.rifin.co.za/) and add your DB file, open it and then use the buttons on the far right (such as "Insert", "Update", "Delete", etc.) to produce the SQL that will insert to or update the selected table. You can then see the correct syntax and expand on it to add your own values etc. You could also right-click on the results list and select from the menu "Row Actions"-->"Show UPDATE SQL for changing this row" or "Show INSERT SQL for copying this row" etc. There are a myriad more auto-SQL things in there, perhaps a good option if you are learning SQL still. You could also right-click in a query and then select "Copy as Code"-->"Java"/"C#"/ whatever you like, or add your own codify settings for your preferred language to take the pain out of adapting queries to code. The INSERT and UPDATE functions you described should really work in SQL, so perhaps it's a small syntax error or such preventing success. (PS: This list is not a support group for SQLitespeed or any other gui, you may use its own bug/query reporter from the menu to get help there) Cheers, Ryan