Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Modify Form a lot slower than Do Form
Message
Information générale
Forum:
Visual FoxPro
Catégorie:
Gestionnaire d'écran & Écrans
Divers
Thread ID:
00778597
Message ID:
00782513
Vues:
71
>In all my tests tables were open shared. Also, they were all free tables, no DBC involved.
>I am not sure I follow what you did, if I have a table open exclusive, anywhere, I cannot open the form having that table in its DE - I get an error. You say that you can open a table exclusive, and then open a form having the same table in its DE with MODIFY FORM?

Yes, it took me some days before I thought to try what I did today - but it was a *very* impressive test. I'm fairly sure it's related to your problem, as I can also get a similar delay by doing a VALI DATA with a DBC open SHARED with tables open multi-user. Here's what you do for the DE test, and it's easiest to test if vfp is on both machines (though you could use an EXE on PC #1, if you wanted):

1) On PC #1:

a) Open vfp.
b) Type SET EXCL OFF
c) OPEN (or MODI DATA) any DBCs involved in the DE of the slow MODI FORM
d) Then type SET EXCL ON
e) USE some tables that are in the DE (they are now open EXCL, test this with ISEXCL() to be sure).

2) Go to PC #2

a) Issue a MODI FORM on the DE slow form
b) Form will open veerrryyy slowly (but it *will* open, it's only EXCL DBCs that prevent the DE from opening).

3) Return to PC #1

a) Close all tables (but not the DBCs)
b) Type SET EXCL OFF
c) Reopen all tables
d) Now MODI FORM on PC #2 opens right away, at least for me.

This test is repeatable, and has very clear results showing a serious MODI FORM delay, depending on how many tables are open EXCL on the 2nd machine (at least in my environment). Try it, and you should see what I mean. See if it is similar (in delay) to what you are seeing with your DE and free tables.

If your problem is not quite exactly this, I believe it is related somehow. I haven't used free tables much for a long time, but that could explain the difference in your findings and in mine, and why no one else seems to have noticed this MODI FORM delay - probably most of us use DBCs now, especially when using DEs...

Added note: Perhaps the vfp team testers used mainly DBCs to test things like DEs, so your particular (Free tables, DE, & Modi form) problem may well have been missed, at a guess. You could try putting your free tables in a DBC, and see if the delay-problem goes away.
The Anonymous Bureaucrat,
and frankly, quite content not to be
a member of either major US political party.
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform