Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Oracle Remote Views Behaving Oddly?
Message
 
To
All
General information
Forum:
Visual FoxPro
Category:
Client/server
Title:
Oracle Remote Views Behaving Oddly?
Miscellaneous
Thread ID:
00097325
Message ID:
00097325
Views:
55
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?

Michael G. Emmons
memmons@nc.rr.com
Next
Reply
Map
View

Click here to load this message in the networking platform