Sherry-

Just a small addition to Arnon's post:

IF !DBUSED( 'myDBC' )
  OPEN DATABASE myDBC
ENDIF
SET DATABASE TO myDBC
USE myView

Or,

USE myDBC!myView

> 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.