I have two forms in my app which issue a REQUERY to a parameterized view with the following definition.


SELECT *;
FROM ofax!orderitems;
WHERE Orderitems.report_num BETWEEN ?cOrder_ID+"-01" AND ?cOrder_ID+"-99";
ORDER BY Orderitems.report_num


When this statement is executed from the Forms it causes VFP to crash ("This Program has performed an illegal operation" etc., etc.).

But
When in the view designer I can run the view without difficulty.
And
Likewise, I can issue the REQUERY() from the command window with no problem.

I've rebooted, removed the view from my Database, packed the database, rebuilt the query, tested it with-ih the designer, and in the command window. I also removed the view from the form and put it back in again. I then rebuilt the app and ran it.....

Same results....illlegal operation when trying to run the requery in the form.

Oh yeah, I almost forgot....it worked a couple of days ago. The view has not been altered. However, I recently changed the structure of the OrderItems table. (added 2 fields)
But like I mentioned, I've re-built the query since then, and it works outside the form.

Any help would be appreciated....

Rick