How can we help you today?

Start a new topic
Discussions DbVisualizer Forums Support

Sql Server : Data Editor table with computed column

[This topic is migrated from our old forums. The original author name has been removed]

Currently, the Data Editor doesn't work if you try to insert rows in tables containing computed columns (in SQL Server), because DbVis tries to insert values also in computed column. Best regards Michele
2 CommentsSorted by Oldest First
[This reply is migrated from our old forums.]

Re: Sql Server : Data Editor table with computed column
Michele, If you don't want to pass certain cells or columns to the database when save in the data editor, just select the cells and click Undo or right-click and select "Undo". The opposite to force cells to be part of the final update SQL (even if not edited). Right-click, choose Edit Table Data->Mark Selected Cells as Edited. I hope this helps. Regards Roger
[This reply is migrated from our old forums. The original author name has been removed]

Re: Sql Server : Data Editor table with computed column
Hello Roger, Thanks for the answer that solved my problem. Michele
Comments to this discussion are now closed!
More topics in Support
See all 1311 topics