>I have it set to retrieve all records, the assorted requeires are only to enforce filters as VFP will not reqocnise keys in remote views. All views were written with the default view tool and are of the select table_name.* from table_name format. As the view query is read only, how would I change it to read each field name? I am almost ready to rewrite the whole &*%^$# thing using SQL passthrough, but I am on a very short deadline.
What I would do is use the View Designer to edit the view. Remove 1 field only. This will force the designer to use an explicit field list. Click the SQL button to view the SQL Code. Highlight all the code and do a copy-and-paste into a PRG. Quit the designer. Edit the PRG and re-add the removed field to the list. You will need to preface the SQL with a
Create SQL view MyView as . If this is a remote view, put
remote connection MyConnection Share after
MyView. Save and run the PRG.
Mark McCasland
Midlothian, TX USA