Could you post the SQL code that is used to create the view? When I have this problem, it is when I have concatenated 2 or more fields or used trim functions in the field selection list. The error occurs when the first record selected has empty values for those concatenated fields. The initial view structure is based on this, so that concatenated field is not wide enough for populated fields of subsequent records, requery(), etc.
>Hi Folks,
>
>I have a snippet that says (in part)
>
if ! llViewUsed
> use (lcDBC + "!" + lcViewName) in 0
>endif
>
>This gives me a Base Tables Have Been Changed error (1542), but they haven't!
>
>Suspending the app at this point and attempting to USE the (remote against SQL Server) view also generates the error, but modifying the view and running it from the view designer
DOES NOT!>
>This error occurs with a number of the views used by the form (after about 7 have been opened), but modifying one of the views and running it from the view designer and then resuming the app means that the rest of the views load fine as well.
>
>Any clues would be
much appreciated.
>
>Cheers,
>
>Andrew
Mark McCasland
Midlothian, TX USA