The odd thing is, though the view designer shows the SQL as Select * it seems to be storing field names someplace internally. If you reverse two fields and see them ennumerated, you then put the fields back in the orignal order and the SQL goes back to Select *. (I assume all this is common to VFP in general since I confess I never work in the VFP view designer outside of the DBCX in the VFE IDE. < g > )
>>Just a note that might save you some hassle : it is a very good idea when you create a view using all the fields from a table that you reverse the order of two of the fields in the view designer so that the SQL specifies the field names. If not, when you add a field to the underlying table your view is hosed.
>>
>
>Ah...velly crever...
Charles Hankey
Though a good deal is too strange to be believed, nothing is too strange to have happened.
- Thomas Hardy
Half the harm that is done in this world is due to people who want to feel important. They don't mean to do harm-- but the harm does not interest them. Or they do not see it, or they justify it because they are absorbed in the endless struggle to think well of themselves.
-- T. S. Eliot
Democracy is two wolves and a sheep voting on what to have for lunch.
Liberty is a well-armed sheep contesting the vote.
- Ben Franklin
Pardon him, Theodotus. He is a barbarian, and thinks that the customs of his tribe and island are the laws of nature.
