Edit Data: Insert in table with identity fails about azuredatastudio HOT 4 CLOSED

Hi @mrg3d, thanks for your report! Can you provide the schema of the table you're trying to edit and which columns you're trying to edit? The editor is supposed to disallow editing identity columns, but it's possible there are scenarios we're not addressing correctly.

This issue may be addressed with microsoft/sqltoolsservice#533, but I'll need to verify this more carefully with your scenario.

from azuredatastudio.

Hi @benrr101,
At the moment I haven't the exact schema... but I got the error on more than one table.
Each one with an identity column specified. On monday, once at work, I can give you one.
But I'm pretty sure you can try creating one and replicate the case.
For example try with

CREATE TABLE dbo.TestIdentity (
IdentityColumn INT IDENTITY(1,1) PRIMARY KEY,
ValueColumn1 VARCHAR(100) NULL,
ValueColumn2 VARCHAR(100) NULL,
)

This is a schema very very similar to the one I was working on.
Well.. trying enter data manually, for exemple in col "ValueColumn1" (not in the identity col... obviously :) ) I always received the error.

from azuredatastudio.

Hi @benrr101,
This is the exact schema of my original table:
CREATE TABLE dbo.MarkupRules (
RowId INT IDENTITY(1,1) PRIMARY KEY,
CompanyId INT NULL,
SupplierId INT NULL,
CustomerId INT NULL,
FromDate DATE NULL,
ToDate DATE NULL,
Percentage DECIMAL (5,2) NOT NULL
)

.. and this is a partial screenshot of the error I get trying to confirm my row

as you can see I tried entering values in columns CustomerId and Percentage (mandatory)..

Hope this help!!

from azuredatastudio.

I just tried this from my sqlops on mac. The december update resolved my issue.

from azuredatastudio.