>>I've created a view based on the contents of another view. Here's an example:
>>
>>CREATE SQL VIEW view_one AS;
>>SELECT name,color,shape,size ;
>>FROM main!item ;
>>WHERE color = "RED"
>>
>
>
>>CREATE SQL VIEW view_two AS;
>>SELECT name ;
>>FROM main!view_one ;
>>WHERE shape = "SQUARE"
>>
>>When these 2 views are added to a form, both as NoDataOnLoad, I receive the following error:
>>
>>Views require either DB_BUFOPTROW or DB_BUFOPTTABLE
>
>I don't know, what the message means, but I bet, if you comment out the second select, you would not have this error. Try to change your second to from dbf('View_One') Would it help?

Hi Nadya

Sorry, wrong guess. It means the form is not buffered, and, as you know, Views must always use some form of buffering.