>How do you handle TABLEUPDATE when using Cascade deletion??
>I have the following code which, needless to say, doesn't work
>
>
> DELETE
> IF TABLEUPDATE(0,.T.,'Property')
> * cascade delete in referential entegrity deletes persinfo records
> IF TABLEUPDATE(0,.T.,'PersInfo')
> lnRetVal = MESSAGEBOX('Property and PersInfo DELETED!',MB_ICONINFORMATION,'Property Deletion')
> ELSE
> =TABLEREVERT(.T.,'PersInfo')
> =TABLEREVERT(.F.,'Property')
> lnRetVal = MESSAGEBOX('DELETE command FAILED!',MB_ICONINFORMATION,'Property Deletion')
> ENDIF
> ENDIF
> SKIP
>
>
>What do I not understand?

in the else, should read lnRetVal = ...., right?