>The thread you had referenced sounds somewhat familiar in that this error happens sometimes. Also, the view parameters I have are both integer types so the alltrim or padr functions don't apply. Additionally, the view ALWAYS works when I browse it through the VFP interface (after entering the parameters). So I don't think posting the SQL will accomplish anything. I get the error on SOME parameter combinations when using the standard business object of the MERE Mortals Framework and executing the requery method of the business object.
>
>Are you familiar with MERE Mortals?

Yes. I have over two years of experience developing in MM. I've definitely seen my share of wierdness with views. It can be the properties of the view and not the SQL itself that cause strange behavior. I normally use ViewEditor from Steve Sawyer for all my view editing etc.

Dan