Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Insert into VS TableUpdate with Buffering on
Message
Information générale
Forum:
Visual FoxPro
Catégorie:
Gestionnaire d'écran & Écrans
Divers
Thread ID:
00125610
Message ID:
00125625
Vues:
13
>>>>If have a form with the bufferig on ( pessimistic row beffering) and I have a special function that will insert many copy of the record in a table.
>>>>ex:
>>>> For x = 1 to lNbToAdd
>>>> Insert into MyTable ( ...
>>>> endfor
>>>>
>>>>Do I need to do the tableUpdate in the loop or only after the loop?
>>>
>>>Personally, I don't use pessimistic buffering and can just guess that when you move record pointer (and INSERT really does it) you will trigger tableupdate() for row buffering automatically.
>>
>>So I need a tableupdate() after the loop for the last insert?
>>
>>BTW the "pessimistic row beffering" is use for a special case but the same question apply to Optimistique row buffering.
>
>I think it would be even simpler to move pointer one more time when loop is finished.
So something like
for x = 1 to nbtoadd
insert into mytable (...
endfor
lncur = recno()
go top
go lncur
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform