>>>>>Thanks Trey
>>>
>>>>
>
>Hmmm doing it this way seems to work though!!!!
>
>sele v_ticket
>*!* DBSetProp("v_ticket.p_ticket", "Field", "Default", "NextKey('P_TICKET')")
>insert into v_ticket (p_ticket,ticket) values (NextKey('P_TICKET'),myvalue)
>go recno()
>wait window ' v_ticket '+trans(v_ticket.p_ticket)+' ticket '+trans(ticket.p_ticket)
>return v_ticket.p_ticket
>
>Thanks for the idea of populating v_ticket with the primary key before I write the record back to the underlying table.
>
>I had been told in the past that this was a bad idea and I should insure nextkey only ever gets run from the one location.
>
>It looks like this is one of those general rules that needs to be broken from time to time for the sake of performance.
>
>I am pleased becuase it would have been very time consuming requerying the whole view just to get my primary key reflected back into the view.
>
>
>
Glad you got it working and that I could help.
Insanity: Doing the same thing over and over and expecting different results.