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