Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
OLE DB and parameterized views
Message
General information
Forum:
Visual FoxPro
Category:
Other
Title:
OLE DB and parameterized views
Miscellaneous
Thread ID:
00658224
Message ID:
00658224
Views:
46
OK, I have a database that we have been using for many years and have set up just about any view a person would require in order to get data out of the database. Mostly all views use a parameter (e.g ?vp_docnumber). Now we will be converting our application to the web and I would like to use OLEBD to get to my database, but I am having a problem with using a view that has a parameter. I get an error that states 'OLEDB Error Code = OSQL: Column 'VP_DOCNUMBER' is not found.' So my question is this, do I give up on OLEDB or will a future VFP OleDb driver resolve this issue so that parameters are recognized somehow. We have invested a whole lot into the views and I really do not want to have to create another set that is modified for OLEDB use.

TIA
Bret Hobbs

"We'd have been called juvenile delinquents only our neighborhood couldn't afford a sociologist." Bob Hope
Next
Reply
Map
View

Click here to load this message in the networking platform