Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Refresh grid with a remote view
Message
 
 
To
15/07/2003 10:54:54
Xiaodong Yan
Better Database Solutions
Spring, Texas, United States
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00809387
Message ID:
00811542
Views:
22
Sheldon,

I would use a single view, during the refresh phase you should give your users some sort of visual cue that the data is being refreshed. Client/server apps just have to work a little differently than native VFP tables, some things will be faster some things will be slower, you set the user expectations.

>Thank you! Tried the trick. Although the grid stopped flicking, user will feel couple seconds hold because of the screenlock. Seems to user, the program "stuck" for 2 seconds and their mouse click won't work... I am upgrading backend database into SQL, the grid design works perfect currently with natual VFP table.
>
>Any other way to refresh my view for the grid without requery(i.e.,purge/refill)? Do I need 2 views? one used for display, the other used for update? or a local temp table and a view, where the table is used for display and the view is for requery and update my local table? the two will out of sync?
df (was a 10 time MVP)

df FoxPro website
FoxPro Wiki site online, editable knowledgebase
Previous
Reply
Map
View

Click here to load this message in the networking platform