I have received this error message when the structure of the underlying table has changed and the view is updatable and uses SELECT *

For some reason VFP chokes when you change the structure of the table, even if you only add a new field and don't delete or modify any of the existing fields.

The way I have worked around this is to never use SELECT * in my views. If I need to select all fields in a view I select them all one by one (rather than we the asterisk.)


>Hi,
>I have a client that is getting 1542 error which is - view does not match the table. This program has been running for years and when we check the view in question from the command window it gives no such error. I noticed that the underlying temp (something like c:\temp\501232.tmp) does not exist. It appears that something has changed and is not creating the temporary tables. Has anyone run into this in the past or can shed some light. Since "C" drive is owned by the user I don't believe it has something to do with permissions.
>John