>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