How to edit results?
Hi, I just activated my premium license, but I do not see how you're supposed to be able to edit the results of your query?
Can anyone point me in the right direction? I see on the site, screen shots that show add/delete row, but how do I get there?
Can anyone point me in the right direction? I see on the site, screen shots that show add/delete row, but how do I get there?
Comments
It turns out as I'm using the IQ driver, it seems that editing data with it is not supported at the moment.
Unclear to me whether or not they will allow that later or not, which is a big bummer for me as all the databases I need to connect to are either Oracle or MySql.
Also there are quite a few limitations with the IQ driver with nullable FKs in queries and sometimes it generates queries with join types that are not in oracle at all.
LINQPad uses LINQ to SQL for editing results, so it won't work with a plain SQL query. You also need to select the entities themselves, it won't work with a projection.
>It turns out as I'm using the IQ driver, it seems that editing data with it is not supported at the moment.
I have activated premium license but I also cannot edit data on SQLite DB on IQ driver.
>If you right-click a table in the schema explorer and choose 'View/Edit top 100 rows', do you get a grid with an Edit button the top?
No. 'Edit Data' does not appear. Is there any way to do it? Note that I can edit data using sqliteadmin.exe.