Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Requery on view returns nothing
Message
General information
Forum:
Visual FoxPro
Category:
Client/server
Miscellaneous
Thread ID:
00064124
Message ID:
00064146
Views:
33
>I tried both requery("viewname") and =requery("viewname").
>The strangest thing is that if I use the view without nodata and then do a requery my data dissapears. The requery executes but the view returns empty!
>
>>>It still does'nt work. And just in case you were wondering when I just use "viewname" without the nodata parameter it works just fine!!!
>>>
>>>>Jonathan,
>>>>
>>>>It looks like your view may be referencing the _field_ no_hist rather than the memory variable no_hist. Re-write your view to use no_hist=?m.No_Hist
>>>>
>>>>
>>>>>I have a simple remote view with a filter that says no_hist = ?no_hist
>>>>>
>>>>>Here is my code
>>>>>*
>>>>>use "viewname" nodata
>>>>>...some processing here
>>>>>no_hist= 1299
>>>>>requery("viewname")
>>>>>*
>>>>>
>>>>>The problem is I don't get anything back when I browse the view. Even tough the 1299 records exists!!!
>>
>>Do you call "requery()" or "=requery()" ?

But I hope, it works from Command Window?
Edward Pikman
Independent Consultant
Previous
Reply
Map
View

Click here to load this message in the networking platform