>You created remote views and opened them with NoDataOnLoad, then you specified your paramaters as private variables and issued a REQUERY() and got an error. When you run the same SQL with single quotes instead on double it works.
You're correct except the remote view is creating the SQL and I'm not getting an error, just no matching data. In debug the value of vp_cChar4 is "MB" not 'MB'.
>Are you using the LIKE instead of = in your WHERE condition and adding a % sign at the end of your view parameter?
I've tried LIKE but the % is unknown to me. Where does the % sign go?
TIA,
Rex
Rex A. Willis MCSD