>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
Sunshine,
If the above is your litteral code, the FLock migh failt. If that would be the case because someone else has FLocked the table, the append will wait for the table to get freed from the FLock, and you user might be able to press Esc. In this scenario you won't loose data, and instead it never was there.
Peter