Hello everyone,
=SETFLDSTATE(lcPrimaryKey, 3)
This line of code in the business objects OnNew method is the culprit. By setting the field to look like no change has occurred to an appended record when the update is passed to the base table it regenerates any required defaults. Thinking all of those fields are unchanged or basically blank.
So Stephen was right but we couldn't see it becuase of the confusion that SDT caused for us.
We got bit twice.
What a life,
Bill
William Hartgrove
Senior Elephant Waxer
Hartgrove Amusent Park and Youth Hostel
Austin, Texas