>>If I understand correctly, COPY TO can't copy related fields from other tables, or, for that matter, any expression. Of course, I can use SELECT - SQL, but that won't respect the filter and sort order of the currently selected table.
>>
>>Any ideas?
>
>You can use current filter as WHERE clause and current order as ORDER BY clause in the query.
While thinking about this approach, I remembered another problem. Part of the "tables" are actually views. While I think I can SELECT from a view, I also have to find, and populate, the view parameter - arghh.
COPY TO would really solve all cases, if it only accepted an arbitrary expression.
Hilmar.
Difference in opinions hath cost many millions of lives: for instance, whether flesh be bread, or bread be flesh; whether whistling be a vice or a virtue; whether it be better to kiss a post, or throw it into the fire... (from Gulliver's Travels)