David,

I'm sorry. I did not understand yor answer. Where should I put the brackets ( and ) in the SQL statement.

Thanks


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