>Is there an easier way of closing a bunch of tables, but not all the tables, than:
>
>SELECT mytable1
>USE
>SELECT mytable2
>USE
>
>Etc?
>
>What I'd like is something like:
>
>CLOSE TABLES mytable1, mytable2
>
>But what I read in the help about CLOSE TABLES doesn't sound like you can do that. Is there another command for that?
>
>Thanks,
>
>-Michelle
Hi Michelle,
Here's another idea. Use AUSED() to populate an area, and loop through the elements and close the tables. By default, AUSED() is scoped to the current data session. This means that if there are any cursors created in the data session, they should be included as well.
hth,
George
Ubi caritas et amor, deus ibi est