>To All,
>
>I have application in vfp7 using sql database, i have series of sql remote views recently i always encountered same problem says : "Base Table fields have been changed and no longer match view fields. View field properties cannot be set." I always open the remote view and reset the key then save again. Is there any other way to avoid such error because it gives headache resulting to inconsist data.
>Thank you in advance..
>
>Thess
Marites,
2 things come to my mind :
1) Your view definition was something like :
select * from ....
Then any structural change in base could make fieldnames not to match DBC stored ones.
2) Calculated fields or expressions that have impact on width of returned data (for such field expressions use expressions that would fix the width)
Cetin