No I cannot do this , because the query may come from a remote dbms ..., and then i get a cursor ...

Dim.

>Is there any way you could SELECT the query into a Table.
>
>

SELECT * FROM MyTable INTO TABLE AnotherTable

>
>Kev
>
>>It wont work for two reasons:
>>1.I want the table to be closed when it leaves from the middle-tier and because the table is a cursor when you close it, it is been lost
>>2.If you dont close the cursor you get the error: file is in use, at the presentation tier ...
>>
>>Thank You
>>
>>dim.
>>
>>>>pleas tell me if that works.
>>>>
>>>>I know I have done this before but fail with Error 'Not a file' or so
>>>
>>>Agnes,
>>>
>>>This should work. The cursor's base table is stored in the temp directory and using DBF with the alias should return it. Of course, it is only as permanent as the files in the temp directory are...
>>>
>>>Renoir
>>>
>>>Dimitris: FYI as you originated the thread.