Clarion 5.5 an MsSql Timestamp field

sql
Tags: #<Tag:0x00007f6fdfd69858>

#1

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.


#2

In your dictionary go to the external name field for your timestamp column.
Enter the column name followed by | READONLY.
MyField | READONLY

If I remember correctly, back in C5.5 Clarion would still occasionally try to send a value for a READONLY column in some update statements.

Your only other option is to remove the timestamp column from the Clarion dictionary and then Clarion won’t know about it and try to update it. Just let the back end manege the column.


#3

It works thank you for your answer