>When I open a table (SaleTemp.dbf) in my app, I want to be sure that it is empty. So here is what I do:
>
>IF RECCOUNT() > 0
> USE
> SELE 0
> USE SaleTemp Excl
> DELETE ALL
> PACK
> USE
> SELE 0
> USE SaleTemp
>ENDIF
>
>The problem is that optomistic row buffering, which is set for the form, is, from the error messages I get, lost (I can't, for example, TABLEUPDATE()). If I REM out the above code, everything works.
>
>Why? How should I handle this?
You can use Cursorsetprop to turn off buffering while you Zap, at least that's what I do for this. Have you tried this? (BTW, Zap is faster than Delete All/Pack)
The Anonymous Bureaucrat,
and frankly, quite content not to be
a member of either major US political party.