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
>

Reply via email to