Entering rows into table

[firebird_hunter]

Hi,

I am evaluating in the moment dbForge for SQL server.
In my databases I have columns with a user id and a datetime2 value as timestamp. The table creation source looks like

Code: Select all

CREATE TABLE [Spiel-DB].dbo.tblTest1(
  id INT IDENTITY,
  [user] INT NOT NULL DEFAULT (suser_id()),
  stamp DATETIME2(0) NOT NULL DEFAULT (sysdatetime()),
  CONSTRAINT PK_tblTest1 PRIMARY KEY (id)
) ON [PRIMARY]

Entering datas with MS SQL Management Studio works fine as well with the running applications or stored procedures.

In dbForge I cannot enter data in these tables, because the given default value or function is not taken into account, the fields are staying null, and null cannot be entered.

Is there any way how to enter datas in this kind of tables?


Regards,

firebird_hunter

[alexa]

Please note that in fact the default values are entered automatically once you commit changes in the new record. You just need to refresh data in the grid after you added the new record.

[firebird_hunter]

Dear alexa,

thanks for your reply. But you are not able to add a record, so refresh is not an option.
Did you tried to enter data with the given sample table?

[alexa]

We have been able to successfully add records into the mentioned table.

Could you please provide us the screenshot reflecting this issue along with the full text of any possible error message? Please also describe us the way you are trying to add records into the table and specify the versions of the SQL Server and dbForge Studio for SQL Server?

[firebird_hunter]

Dear alexa,

ok, the way trying to enter data: First clicking "Append" thereafter direct "End Edit", because there is no data to enter! And then, a error.

I cannot attach an image, so here the exact translated error message:

NULL cannot be inserted in to user-column, Spiel-DB.dbo.tblTest1-Tabelle. The column does not allow null-values. Error by INSERT.

Version: dbForge Studio 3.0.136 Prof. (Trial) and SQL Server 2012 SP1

[alexa]

Thank you for the reply.

We were able to reproduce this issue and will fix it in the next build of the product. We will notify you once the new product build is available for downloading.