David,

I can use the view in the command window fine but the only place the requery works is in the load of the form. Bombs anywhere else in the form. We even tried deleting the table the view is based on, recreating it, and rebuilding the view. No luck. We are using the View Designer.

Thanks for your help!

Sally



>Sally,
>
>Can you use the view in the command window?
>
>SET DATABASE TO TheDatabase
>vParm = SomethingAppropriate
>use view_receipts
>
>Is the view created in the View Designer or done with a CREATE SQL VIEW?
>
>>I am using VFP 5.0a under Win95. I have a form that requeries periodically (or tries to). When the =requery("view_receipts") command is issued, I get a GPF invalid page fault. This happens consistently on the same requery.
>>
>>I traced thru the code, moving the requery statement around to see if it generates an error everywhere. In the load, it requeries without an error. In the init, I get the error. It is a parameterized local view. I open the view in the data environment with buffering set to the form setting (pessimistic). I then index the view in the load event and change the buffering to 5 with cursorsetprop. There is no data on load for the view and no order set in the data environment. The requery in the load event after setting the buffering does not give an error. In the Init event, I get the error if I requery before I set the property for the parameterized part of the view or if I requery after the property is set.