General information
Category:
The Mere Mortals Framework
>I've got a form based on cBizObjModalForm. I've got a listbox on the left hand side. On the right hand side there are 15 textboxes (cTextboxl). When the user clicks on an entry on the list box, the text boxs on the right are updated. In the Click() method I've got the following code:
>
>LOCATE FOR v_Standings = THIS.Value && THIS.Value has the cID of entry.
>THISFORM.Refresh()
>
>(I tried using the LockScreen property but didn't notice a difference).
>
> There is a 1.5-2.5 second delay from when I click on a entry until when the new values appear. I created 3 indexes on the view in adataenv.prg:
>
>
>lcIndexExpr = 'INDEX ON DELETED() TAG deleted'
>This.....
>lcIndexExpr = 'INDEX ON PRODSTATUS TAG Prodstatus'
>This.....
>lcIndexExpr = 'INDEX ON cID TAG cID'
>
>None of this has helped the speed at all. The v_Standings view probably has less than 100 records (and 90 of them are deleted). Any suggestions to optimize this screen?
Why don't you use SEEK ? You will only need to index the view on cID...
seek this.value
BOb
Previous
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only