Sorry, I don't quite understand your reply. Obviously, table should be open, and open exclusively, when you index it. Again, you better use cursor because it's always opened exclusively and again you can index it on procedure. What error you received?

>Hi Edward,
>
>Even though I can index on a PRG, if tables are not all open,
>only those that are included in the PRG I am getting an error message. It is
>impossible to keep open in development time. When I close the form all tables
>are closed for this session, then again I am getting an error.
>
>Any ideas ?
>
>Thanks
>
>Doron
>
>>>
>>>DO CASE
>>> CASE PctDist.lPct_Cancelled
>>> *** Blue
>>> *** If Cancelled=
>>> RETURN RGB(0,255,255)
>>> CASE dSystemDate>>> ***Yellow
>>> *** For future LDI
>>> RETURN RGB(255,255,0)
>>>ENSCASE
>>
>>Sorry, I have to add one more thing. I tried it, it works OK when indexed on >procedure from system procedure file (as expected), but for some reason >generates an error when indexed on form.method. So, it might be better for you >to use procedure.

Edward Pikman
Independent Consultant