>I grabbed the SQL code from the view and in place of the parameter, I entered the actual value; this was outside of the program.
>
>Now, a little while ago, as I ran the program, I had already grabbed the actual code and then executed that and got the result even with the ThisForm.cProject_No variable. It's just when I run the view within the form, I don't get any results.
>
>And, why would this be working for some time and now, all of a sudden, it just stops working? Either this is a VFP bug, or the data has changed. I checked out indexing and that doesn't seem to be a probem either.
I don't know, really. But: is the parameter of type numeric? 'Cause if it is of type character, settings like SET EXACT can be relevant.
Difference in opinions hath cost many millions of lives: for instance, whether flesh be bread, or bread be flesh; whether whistling be a vice or a virtue; whether it be better to kiss a post, or throw it into the fire... (from Gulliver's Travels)