Thanks Ryan, I will definitely try it. I'm ok with raw SQL, just not familiar with the odd ones like this multiple rows update.
Thanks a lot, Chris On Tue, Feb 9, 2016 at 12:42 PM, R Smith <rsmith at rsweb.co.za> wrote: > > > 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 > > > _______________________________________________ > sqlite-users mailing list > sqlite-users at mailinglists.sqlite.org > http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users >