Re: [Squirrel-sql-users] cannot edit sql results of a JOIN statement

[luca <luc...@gm...>]

@Alex, I think this is not a nightmare, /for some specific databases/.

For example, Oracle allows updating on a view via SQL command, just like 
on a table (under some restrictions I don't remember exactly).

see e.g. https://stackoverflow.com/questions/1652995

Luca



Il 24/05/2018 21:35, Alex Malmyguine ha scritto:
> I'll be very surprised if this is at all possible. Definitely not something I'd expect from an SQL client.
> Implementing that would require tracking of which column comes from which table. And then there is duplication of records... A nightmare for developers with very little to gain for users.
>
>
> -----Original Message-----
> From: Federico Bruni <fe...@in...>
> Sent: Monday, May 21, 2018 12:38 PM
> To: squ...@li...
> Subject: [Squirrel-sql-users] cannot edit sql results of a JOIN statement
>
> Hi all
>
> I see that Squirrel SQL does not allow to edit the content of a JOIN
> result.
>
> ------------------------------------------------------------------------------
> Check out the vibrant tech community on one of the world's most
> engaging tech sites, Slashdot.org! http://sdm.link/slashdot
> _______________________________________________
> Squirrel-sql-users mailing list
> Squ...@li...
> https://lists.sourceforge.net/lists/listinfo/squirrel-sql-users