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?
Paul,
If this is the actual code in the LOCATE, LOCATE FOR v_Standings = THIS.Value, then it looks like the problem is the LOCATE. Should this not be something like LOCATE FOR v_standings.field = this.value?
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