>>Hi all!
>>
>>I'm getting an error which I can't figure out why...thus it's hard to debug ;^). I've used two SQL commands to create two views. I'm using the second one as a source for a report. I thought all was fine, but when I try to use the second view, rvmajorap2, I'm getting the following message:
>>
>>"Base table fields have been changed and no longer match view fields. View field properties cannot be set (Error 1542)"

>My guess is that you are not creating the SQL view each time but rather justing using the already created views: rvmajorap1 and rvmajorap2 to generate the reports.
>The issue is that the base table structures probably changed from the time you first created these SQL views in the database. I've run into similar problems in the past when I've modified the structure of tables that were involved in SQL queries. Even though the query itself would run (as a SELECT statement from the command window, not as a USE statement from an already created SQL view) on the new table structures because the syntax is correct, the SQL view saved in the DBC was out of sync because the structure of the resulting view is saved in the DBC, not just the SQL syntax that creates the view. Just DISPLAY DATABASE and you'll see the list of fields and their characteristics for the SQL view. My suggestion is to delete the two offending views from the database before executing the CREATESQL VIEW statements again. That will bring the views and the underlying tables back in sync.
>Good Luck,
>-Dore

You were right on target. I reran my createsql statements and things are working like a charm. Thank you very much!

Mandy