Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Oracle and parameterized views
Message
General information
Forum:
Visual FoxPro
Category:
Other
Miscellaneous
Thread ID:
00131337
Message ID:
00131467
Views:
19
>Noticed these messages, thought I'd put my two cents in. I just have a regular membership and can read the article (and have a few times as matter of fact), so you should be able to read it.
>I also noticed your thing about the paramters for the remote view. If you use the LIKE command you need to use a '%' somewhere in there too, you may want to check with Mark, I've just go into Oracle myself, but I know that you need the percent sign in there somewhere.
>
>>Finally some good news -- of course I have to ask again for my own sanity -- You are use remote parameterized view (... where city like ?pcCity ...)????
>>

The variable (parameter) should have the percent signs included.

pcCity = "%" + AllTrim(CityString) + "%"
Mark McCasland
Midlothian, TX USA
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform