Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
SQL, AS/400 and view parameters
Message
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Miscellaneous
Thread ID:
00116137
Message ID:
00116153
Views:
20
>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
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform