>Hi there,
>
>I'm using VFP 7.0 and am getting "There is not enough memory to complete this operation" error message after setting a couple of tables to BUFFER. This is my buffer code:
>
>select instance
>=cursorsetprop('buffering',5)
>select results
>=cursorsetprop('buffering',5)
>
>After making my multiple INSERTS, here's my commit code:
>
>begin transaction
> select instance
> llupdate = tableupdate(.t.,.t.,'instance')
> select results
> llupdate2 = tableupdate(.t.,.t.,'results')
> if llupdate and llupdate2
> end transaction
> else
> rollback
> tablerevert(.t.,'instance')
> tablerevert(.t.,'results')
> endif
>
>I'm seeing LLUPDATE2 equalling FALSE, when all other times I've been using this code (many years now, and has always been stable), LLUPDATE2 has equalled TRUE.
>
>What's really confusing is that other times when there are many more rows buffered, the code works fine. I'm seeing my problem today on only about 35 buffered rows. I have 2 tables open, 2 temp tables, and 3 cursors. I also have several varibles (about 30 or so), but nothing outrageous.
>
>Any ideas on what's going on?
>
>Thanks!
>
>Joe
I'd suspect table header is corrupted (having reccount off by one record) or primary index is corrupted.
Cetin