Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
How to 'rerun' SQL statement Record Source?
Message
From
05/08/1998 14:28:48
Mandy Mccord
Public Interest Breakthroughs, Inc.
Albany, New York, United States
 
General information
Forum:
Visual FoxPro
Category:
Forms & Form designer
Miscellaneous
Thread ID:
00124108
Message ID:
00124202
Views:
29
>>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
Previous
Reply
Map
View

Click here to load this message in the networking platform