Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Slow at the time saving a record in network
Message
From
27/04/2006 20:56:12
Mike Yearwood
Toronto, Ontario, Canada
 
 
To
27/04/2006 16:05:43
Mk Sharma
Shrishti Solutions
Mumbai, India
General information
Forum:
Visual FoxPro
Category:
Forms & Form designer
Environment versions
Visual FoxPro:
VFP 9 SP1
OS:
Windows XP
Network:
Windows XP
Database:
Visual FoxPro
Miscellaneous
Thread ID:
01116489
Message ID:
01117362
Views:
20
SET FILTER on grid? How many records in the list when the requery fires?

>i am using "set coverage to chh.log" to trace where my code taking long time.
>
>it take maximum time in two lines :
>
>Thisform.Pageframe1.Page1.Grid1.colUMN7.SetFocus
>
>&& colUMN7 is first column of grid.
>my grid have more than 20 columns, but hard to fit all the column on the form
>
>suppose user changed something in column no 19 and pressed Alt+S to save the record, at this point my grid showing column no 11 to 19, column 1 to 10 are scrolled in left.
>
>before save the record i want to show the first column of grid.
>
>for this i am using :
>Thisform.Pageframe1.Page1.Grid1.colUMN7.SetFocus
>(result is perfect but tacking long time in network)
>
>below is the second command line :
>
>Thisform.Pageframe1.page2.list1.Requery
>
>i am using a listbox to show all the records in pageframe1.page2.list1
>
>after saving i am using the above command line to requery my list.
>
>may i upload my form on this site.
>
>warm regards,
>mk.
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform