>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?
If it's not broken, fix it until it is.
My Blog