In our company we still use Clarion 5.5. As our database we use SQL 2014. In one table, we were obliged to introduce Timestamp field.
By default, we get following SQL 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.
We tried some things: like:
You have to go to your dictionary, and put the option ‘Insert’ and 'Update’with the value ‘Exclude’ under ‘Options’ for the field
But nothing worked. Any suggestions?
Thank you for your answer.