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