Editing multi dataset query

[goran.genter]

Hi,

I'm a new user of dbForge Studio and I've came by one issue. Not sure if this is proper behaviour but I don't think so.

For example, if I write in new SQL query this:

Code: Select all

SELECT * FROM Activities
SELECT * FROM Holidays

This will return two datasets each in it's own tab.

1. When I try to edit these datasets, everything works fine but the changes are not saved when I click on End Edit.

2. When I try the same thing with Cached Editing enabled, then I receive this error when I click on Apply Changes: "Dynamic SQL generation is not supported against statement that does not contain any key column information".

If I put these two queries each in it's own document, then everything works ok with data editing (meaning I know how to do it).

Question is, why editing is not working with multiple datasets, is this a known issue?
If this is by design, then user should be informed earlier of this - not silently discarding all the changes (in first case) or letting you edit everything and then throwing the error in the final step when you want to apply those changes (in second case)

Best regards,
Goran Genter

[alexa]

We will fix this issue in one of the next product builds and will notify you once it's available for downloading.

In the meanwhile, to avoid this, you can separate statements with GO.

[alexa]

We would like to let you know that we have released a new version 4.0 of dbForge Studio for SQL Server where the issue you reported is fixed http://www.devart.com/dbforge/sql/studio/download.html

Thank you for your help in improving dbForge Studio for SQL Server.