Article: Q130462
\nProduct(s): Microsoft FoxPro
\nVersion(s): WINDOWS:3.0,5.0,6.0
\nOperating System(s):
\nKeyword(s): kbvfp300 kbvfp500 kbvfp600
\nLast Modified: 19-OCT-2000<\/p>\n
——————————————————————————-
\nThe information in this article applies to:<\/p>\n
– Microsoft Visual FoxPro for Windows, versions 3.0, 5.0, 6.0
\n——————————————————————————-<\/p>\n
SUMMARY
\n=======<\/p>\n
This article lists the differences in functionality between two new functions –
\nREQUERY() and REFRESH() – in Visual FoxPro.<\/p>\n
MORE INFORMATION
\n================<\/p>\n
REQUERY()
\n———<\/p>\n
– Retrieves data again for a SQL view.<\/p>\n
– Throws out the current cursor and starts over, possibly with new parameters.<\/p>\n
– Pulls in all rows.<\/p>\n
– Returns 1 if data is successfully retrieved; otherwise, it returns 0.<\/p>\n
– Is typically used to refresh a SQL view when data has changed on the data
\nsource.<\/p>\n
REFRESH()
\n———<\/p>\n
– Refreshes data in an updatable SQL view. It goes back to the server and gets
\nnew values for any rows that you haven’t edited in a buffered view. (It also
\ncaches an image of the rows you have been editing, but it doesn’t force these
\nvalues over the top of your changes.)<\/p>\n
– Is helpful for checking to see whether other users have changed data while
\nyou’ve been buffering.<\/p>\n
– Takes an optional parameter to specify what rows to update, so you can grab
\njust the ones that are currently on the user’s screen, for example.<\/p>\n
– Is a necessary precursor to issuing CURVAL() for remote data.<\/p>\n
– Returns the number of records refreshed. The records are refreshed with data
\nfrom the tables from which the SQL view is created. Records are refreshed in
\nthe SQL view open in the currently selected work area.<\/p>\n
– Cannot refresh locked or buffered records, and the records refreshed must
\nhave unique primary keys. If a record in a table does not have a primary key
\nvalue, the corresponding record in the SQL view is marked for deletion.<\/p>\n
REFERENCES
\n==========<\/p>\n
For more information about REQUERY() and REFRESH(), search for the “REQUERY()
\nfunction” and “REFRESH() function” topics in the Visual FoxPro Help menu.<\/p>\n
Additional query words: VFoxWin<\/p>\n
======================================================================
\nKeywords : kbvfp300 kbvfp500 kbvfp600
\nTechnology : kbVFPsearch kbAudDeveloper kbVFP300 kbVFP500 kbVFP600
\nVersion : WINDOWS:3.0,5.0,6.0
\nIssue type : kbinfo<\/p>\n
=============================================================================<\/p>\n","protected":false},"excerpt":{"rendered":"
Article: Q130462 Product(s): Microsoft FoxPro Version(s): WINDOWS:3.0,5.0,6.0 Operating System(s): Keyword(s): kbvfp300 kbvfp500 kbvfp600 Last Modified: 19-OCT-2000 ——————————————————————————- The information in this article applies to: – Microsoft Visual FoxPro for Windows, versions 3.0, 5.0, 6.0 ——————————————————————————- SUMMARY ======= This article lists the differences in functionality between two new functions – REQUERY() and REFRESH() – in Visual […]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"jetpack_post_was_ever_published":false,"_jetpack_newsletter_access":"","_jetpack_dont_email_post_to_subs":false,"_jetpack_newsletter_tier_id":0,"_jetpack_memberships_contains_paywalled_content":false,"_jetpack_memberships_contains_paid_content":false,"footnotes":"","jetpack_publicize_message":"","jetpack_publicize_feature_enabled":true,"jetpack_social_post_already_shared":true,"jetpack_social_options":{"image_generator_settings":{"template":"highway","default_image_id":0,"font":"","enabled":false},"version":2}},"categories":[13],"tags":[],"class_list":["post-24161","post","type-post","status-publish","format-standard","hentry","category-13"],"jetpack_publicize_connections":[],"jetpack_featured_media_url":"","jetpack_sharing_enabled":true,"jetpack_shortlink":"https:\/\/wp.me\/p6cOVM-6hH","_links":{"self":[{"href":"https:\/\/tom.tomwork.net\/index.php?rest_route=\/wp\/v2\/posts\/24161","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/tom.tomwork.net\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/tom.tomwork.net\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/tom.tomwork.net\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/tom.tomwork.net\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=24161"}],"version-history":[{"count":1,"href":"https:\/\/tom.tomwork.net\/index.php?rest_route=\/wp\/v2\/posts\/24161\/revisions"}],"predecessor-version":[{"id":24162,"href":"https:\/\/tom.tomwork.net\/index.php?rest_route=\/wp\/v2\/posts\/24161\/revisions\/24162"}],"wp:attachment":[{"href":"https:\/\/tom.tomwork.net\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=24161"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/tom.tomwork.net\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=24161"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/tom.tomwork.net\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=24161"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}