Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
How to 'rerun' SQL statement Record Source?
Message
 
À
05/08/1998 13:46:56
Mandy Mccord
Public Interest Breakthroughs, Inc.
Albany, New York, États-Unis
Information générale
Forum:
Visual FoxPro
Catégorie:
Gestionnaire d'écran & Écrans
Divers
Thread ID:
00124108
Message ID:
00124241
Vues:
33
>>Mandy,
>>
>>Try adding the statement
>>
>>thisform.pfAgyCont.pContacts1.Refresh()
>>
>>after your last Requery() statement to refresh the page on your pageframe. You *may* need to refresh each list separately, but I don't think so.
>>
>>As an aside, you may find this style of coding executes faster:
>>
>>WITH thisform.pfAgyCont.pContacts1
>> .cmbATname.requery()
>> .cmbCOname.requery()
>> .cmbCPname.requery()
>> .Refresh()
>>
>>ENDWITH && thisform.pfAgyCont.pContacts1
>>
>>Let us know if this helps...
>
>Evan,
>
>No luck. I tried adding the form refresh line and substituting my code with your WITH..ENDWITH code (neat tip, thanks!) and my lists are still not refreshing until I close/open the form. Ugh!
>
>Mandy

Esteban's correct, Mandy -- the WITH...ENDWITH code needs to be located in the Activate of the first form. You *might* even try putting it into the Activate of the *page itself* -- but I'd try the form's Activate *first* (g).

Don't despair...we'll all help you get this worked out eventually (g).

Evan Pauley
Evan Pauley, MCP
Positronic Technology Systems LLC
Knoxville, TN

If a vegetarian eats vegetables, what does a humanitarian eat?
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform