Hi Jim,

I change the code a bit to see what was going on. It seems that not all the records in the table will make it crash.

IF FOUND()
cntr1 = cntr1 + 1
REPLACE myview1.title WITH mytable.title
all_is_ok = TABLEUPDATE(.T., .F., 'myview1')
IF !all_is_ok
TABLEREVERT(.T., 'myview1')
cntr3 = cntr3 + 1
ELSE
cntr4 = cntr4 + 1
ENDIF
ELSE
cntr2 = cntr2 + 1
ENDIF
WAIT WINDOW "FOUND " + ALLTRIM(STR(cntr1)) + CHR(13) + "NOT F " + ALLTRIM(STR(cntr2)) + CHR(13) +;
"BAD " + ALLTRIM(STR(cntr3)) + CHR(13) + "OK " + ALLTRIM(STR(cntr4)) NOWAIT

By doing this I found that most records are fine. I will have to look deeper into the Database Constraints or something???

Thanks for your help

Mike