Is there an implict loop with LOCATE?
>Accessing a property is slower than access a variable. But still, I wouldn't expect it to be THAT much slower.
>
>
>>Well, it figures . . . I was looking at the code again right after posting this and I believe it's fixed now. In the _ASSIGN method (WorksheetId_Assign, to be specific), I was accessing the WorksheetId form property. Hmmm . . . accessing the property within the _ASSIGN method. There is no _ACCESS method, but I wondered if that was somehow causing a problem. The code was:
>>
>>LOCATE FOR ID = .WORKSHEETID
>>
>>(within a WITH THIS block)
>>
>>So I did this:
>>
>>Ws2Locate = .WORKSHEETID
>>LOCATE FOR ID = Ws2Locate
>>
>>and now it's very fast. Yet the Ws2Locate = .WORKSHEETID line is not slow. So maybe it's a combination of some other factors like the _ASSIGN method, the WITH THIS block, etc. Anyway, it seems to be working fine now.
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