Devart Forums

Hi,
using express-edition of "dbForge Studio for SQL Server" I got a error, when I try to change value in a field.
This occure on last stable version and in the last beta version.
Error-Message when click on "End Edit"
"Dynamic SQL generation is not supported against statement that does not contain any key column information"


Image: http://www.pic-upload.de/view-28893319/Devart.jpg.html
I hope the image is visible.

The List was fetched by the comtext menu command "Retrieve Data"
I have seen the message in the forum, but there was no answer.

Thank you.

Please try turning off Paginal Mode. This can be done either from the toolbar of Data Editor or in the 'Options' dialog:

1. Select 'Tools -> Options' from the main menu. The 'Options' window opens.
2. Navigate to the 'Data Editor -> General' branch.
3. Unselect the 'Use paginal mode by default' option.

Also, please let us know whether you are retrieving data with the 'Retrieve Data' command available in the popup menu of Database Explorer or this is a result of executing some query in SQL Document?

Additionally, please provide us the CREATE definitions of the corresponding table(s).

You can send a reply straight to our support system at supportATdevartDOTcom.

Hi alexa,
I think, I know the problem I had.
The data must be full loaded.
When I have pagination, I have to switch off the pagination and to go to the last record.
then all datarows are load and the field in the grid can be edited and the changes saved.

Thank you for updating us on this issue.