Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
How to 'rerun' SQL statement Record Source?
Message
De
05/08/1998 14:28:48
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:
00124202
Vues:
28
>>DO FORM addcont
>>*!* refresh lists on return
>>thisform.pfAgyCont.pContacts1.cmbATname.requery()
>>thisform.pfAgyCont.pContacts1.cmbCOname.requery()
>>thisform.pfAgyCont.pContacts1.cmbCPCname.requery()
>>
>>But the lists aren't being refreshed until I close the form and open it again. Any ideas where I can look to make this work? Never easy! ;) And I really appreciate your willingness to help!
>>
>
>Mandy,
>
>You have to tableupdate the additions before SQL will get them. SQL, by design, bypasses the buffered edits and adds and gets data directly from disk.

Jim,

Still no luck. I tried:

=TABLEUPDATE(1,.t.,"person")
release thisform

in my FORM2's Save button click with no luck (person table's buffering is set to 1 ..and tried 3 with no luck, form's buffer is none).

I've got a pageframe with pages on this form and when I switch between forms, my changes are occurring. Just not when the user initially returns to FORM1 after adding a contact to FORM2. :(

Mandy
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform