>>>Thanks Trey
>
>>
>>Yep. You can set it with DBSETPROP(), unlike the default for a table field. e.g.,
>>
DBSetProp("v_ticket.p_ticket", "Field", "Default", "NextKey()")
>
>But I can not see how it would help me since my Nextkey routine will return a different value if it is called twice.
>
>And since my Nextkey routine just uses a replace anyway I would expect to still be in the same boat.
It won't get called twice. Since the p_ticket field in the inserted record in the view already has a value, the default of the p_ticket in the table won't fire when the view is updated.
If you don't believe me, try it and see :)
Insanity: Doing the same thing over and over and expecting different results.