Since this is just for a report, I would also just use SQL and forget the view. If this was for data entry as well, then I might have to work on getting the view to work. However, since VFP8 is about to be released, the CursorAdapter is now my preferred method. Bye-bye views!
>aaaarrrrhhhHHHHH!!!!
>
>ok I tried what both of you guys suggested...I still get the same problem.
>
>What is even more strange is if I setup the 3 parameters with values that make it fail...the view does indeed fail and I get the error...BUT if I run the Select statement by itself (not in a view) with the same parameter values it works!!!
>I've spent all day on this ooooone teenee weeene view I think I'm just going to give up and change my code around and hard-code the Select statement in the report...just doesnt make any sense that it doesn't work as a view (sometimes)..grrrrrrr. I'm quite frustrated I mean this is like a pretty simple view to begin with.
Mark McCasland
Midlothian, TX USA