If you need to fetch all the reports (I am assuming that the max range is from 1 to 99) then following should work as long as you have EXACT turned off.
SELECT *;
FROM ofax!orderitems;
WHERE Orderitems.report_num=?cOrder_ID ;
ORDER BY Orderitems.report_num
>>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
>
>
>Turn your attentions from the view to the form. My guess is that you have a grid on the form that is based on the view, and one or more of the columns has a funky controlsource. If not, check and double-check the controlsources of all bound controls on the form.