Devart Forums

Posted: **Fri 30 Nov 2012 21:09**

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

Posted: **Tue 04 Dec 2012 11:21**

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.

Posted: **Tue 04 Dec 2012 13:38**

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?

Posted: **Tue 04 Dec 2012 14:14**

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?

Posted: **Tue 04 Dec 2012 18:19**

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

Posted: **Wed 05 Dec 2012 13:01**

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.

Devart Forums

Entering rows into table

Entering rows into table

Re: Entering rows into table

Re: Entering rows into table

Re: Entering rows into table

Re: Entering rows into table

Re: Entering rows into table