>hi,
> think you for your help, but what I need to know is how do I open the result set at run time. for example: if I am using a table the command I use is "use mytable" what is the command for a view ??? thanks.

use myview nodata
or
use myview

just as you would with a table

Arnon