>I have a remote view to an oracle table. The view has a view parameter on a character field. If I run the sql from the view designer and enter "U6 " as the view parameter one record is returned. "Great. It works," I think. I close the view designer and open the view up from the command windows. I assign vp_custcd = "U6 " (the exact same value in the view designer) and requery. Zero records returned. Huh? If I change the view parameter to "U6" it returns the correct single record. I've tried turning exact off with no difference. Is there something I am missing here?
Argh! In my browser is shows the all the "U6" values with no spaces after the 6. The first two times I requeried I used the value "U6---" where "---" are spaces. The last time I used "U6" and it worked.