This is odd and has only started happening in the last few days.
I have some simple Dexterity sansScript code that does the following (this is not the actual code):
RecordKey of table xxx = RecordKey of window abc;
SequenceNo of table xxx = SequenceNo of window abc;
change table xxx;
if err() = MISSING then
save table xxx;
else
release table xxx
warning "duplicate record";
end if;
Now, my problem is that the even is the record is new and doesn't exist, I am getting a error code 17 (duplicate record) when it hits the save table command.
I do not understand why this is happening. I am checking to see if the record is missing, therefore a new record, but when it saves it is saying it is a duplicate.
This is now happening in 2 different scripts and only started a few days ago. I am not sure what is happening.
Does any Dexterity developer have a clue?
