>Hi Nadya,
>
>it is a INNER JOIN matching.
>
>1. Solution ( code optimization), reverse JOIN order:
>Search comma-delimited list of codes into the array using ASCAN() function.
>
Hi Fabio,
Yes, I was thinking in this direction, but the code is going to be much more complicated. First I need to parse the string, then since I'm using VFP6, do some special procedures in ASCAN to ensure the correct column, etc. So, the question is: is it worth the trouble. I guess, I have to program and compare speed difference in instantiating the form.
>2. Solution ( implementation optimization), define a index:
>use ItemId on ListBox like a index for codes.
>
Don't understand this idea. Would you please elaborate?
If it's not broken, fix it until it is.
My Blog