G'day Doug,

There's an option in the view designer to do updates in this way (delete and then insert). It's in the update criteria tab on the bottom right of the page.

The CURSORGETPROP() property is UpdateType - 1=update, 2=delete and insert

Cheers,

Andrew

---

>Hi,
>
>I am having a nasty problem with one of my local views. Whenever the following code is run, the original record in the base table is deleted and a new record created.
>
>***********************************************
>* Update the last_invno & last_invdate in jobhed
>vcJobIdNum = mjobidnum
>minvno = Varinvhed.invno
>SELECT vJobhed
>=REQUERY()
>IF RECCOUNT() <> 0
> REPLACE last_invno WITH minvno,last_invdate WITH oParameter.dParm1,ed_date WITH gdSysDate, ;
> exp_type WITH IIF(EMPTY(exp_type),'C',exp_type),username WITH gcUserName
> IF TABLEUPDATE(.T.) = .F.
> ?? CHR(7)
> =MESSAGEBOX('Unable to update this record!',0+48,'&gcMessage')
> =TABLEREVERT(.T.)
> ENDIF
>ENDIF
>************************************************
>
>I have never come across this problem before (have been using parameterised views a while).
>
>I am using VFP6 SP3 on a WIN NT 4.0 SP5 WorkStation.
>
>I hope some one can help.
>
>Regards
>Doug Johnston