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.