>>I have to edit a report that has one field with expression created by a function. Since function is in a procedure file, report runs very slowly.
>>How can I embed this function in the report?
>>
>>Thank you
>>
>>Ed
>
>>Why do you think the slowness is attributed to the fact, that your function >is in procedure file? Did you try with only this function in a procedure
>>(no more extra functions there)?
>
>This field expression was created with a sequence of embedded IIF statements. Several new conditions were added to this field and expression became too large and did not fit into expression size limit. I was forced to create a function and move it to a procedure file. Since this application actually is very old and has a lot of complex procedures inherited from FP-Dos, it's difficult to find and risky to change anything in codes.
>It's easy for me to create a cursor with report data, but it will go through a sophisticated chain of procedures with indexing and so on...
>
>Thanks
>
>Ed
Then just do pre-processing on your cursor instead. May be it would be quicker.
If it's not broken, fix it until it is.
My Blog