I want to copy data between two copies of the same object (create replica of the table) using SQL statement.
insert into [Test Table 02] select * from [Test Table 01]
It gives an error:
Cannot insert an explicit value into a timestamp column. Use INSERT with a column list to exclude the timestamp column, or insert a DEFAULT into the timestamp column.
As suggested by the error message I can change this code into
insert into [Test Table 02] (field1, field2,...,field100) select field1, field2,...,field100 from [Test Table 01]
insert into [Test Table 02] select DEFAULT,field1, field2,...,field100 from [Test Table 01]
But I don't like those... I need a solution without listing the columns.
According to help, for example, when you use TRANSFERFIELDS(..., FALSE) in NAV - timestamp value will not change. How they achieve this?
Is there any setting which forces SQL to accept value in timestamp field?