Information générale
Catégorie:
Codage, syntaxe et commandes
Titre:
Having trouble with BUFFERING and TABLEUPDATE
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
Suivant
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement