Just an idea. It looks like STORE command is supported by VFP OLEBD provider. You can try to assign value to 'VP_DOCNUMBER' variable before using a view.
>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
--sb--