>James-
>
>If you really need to get at the already open table, you could have a open table registry in your application object where tables are registered as opened when they are opened. But, AUSED is very much the way I would do what you are talking about.
>
>I can think of one contingency you might want to consider: if you are using views, the base tables for views will also be in the AUSED array. Whether that affects your design or not, I don't know.
>
>>So I can search for a table that might be already open under another alias. If there is a quicker way to do this besides looping through all the used workareas, I would certainly like to know it.

Hi Nancy,

You are more than welcome to jump in at any time.

This whole thing is not the way I'd do it at all, but I'm working with legacy code and a delicate political situation.

The code now runs through all work areas from 1 to SELECT(1) (32767) which seems kind of excessive. I think it would work just as well if the program did not check a bunch of empty workareas. That's why I'm looking for the highest used work area.

I don't think views in AUSED() will affect this operation.

Thanks for your help.

regards,