Rick,

It's a limitation of the view designer. If your database is currently selected the CREATE SQL VIEW statement you have there will put the view into the database.

>CREATE SQL VIEW request A AS;
>SELECT * FROM A;
>WHERE Request.USER_CLOCK LIKE ?cuser_clock;
>AND Request.AREA LIKE ?carea;
>AND (Request.MNRCAT LIKE ?cmnrcat OR Request.MNRCAT IS NULL);
>AND (Request.STATUS LIKE ?cstatus OR Request.STATUS IS NULL);
>
>I know that to get around this problem, you have to do it programmatically in a .prg, but I dont know how. Can anybody help me with it??