>I am new to working with views against a back-end database. I have done
>pass-through work for some time.
>
>First:
>In the load of a form I create several views ( 2 updatable ) from code.
>Two of these are updatable views. The form works fine in development,
>but when I build an exe, it fails to find one of the "dbf's" that is
>supposed to be a view.
I'm having the opposite problem, when I try to do it from the command window - simply because the view is trying to use a dbf which is in another dbc which is not in the path. In the executable there's an utility which sets the path, and there it works.
So my recommendation would be to make sure the dbc (or the dbf) is visible to your exe - somehow it is, while in VFP, but not in the exe.
>Second:
>When I attempt to modify the views in the database interactively, I get
>errors ( "function missing ')'" or "Sql cannot locate table" ) One of these
>is updatable, one is not, several of the others open just fine. Any one
>know what gives.
Sounds like something in stored procedures that doesn't really get right, or a pathing issue again. Don't really know.