You can check the _TALLY system variable for the # of added records.

>I'm maintenancing a program in fox5. Once in awhile the append does not work and we lose data. Here is the code:
>
>use lifs
>t1b = flock()
>append from lifcdprt
>set talk off
>close databases
>
>Now I've done a little research and learned that an append does not need an flock() but wasn't sure if this could be causing the problem. If the code is correct, is there a way to check if an append is successful?
>
>Thanks,
>Sunshine