>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)"
>
>I don't recall any changes to the base table, so I'm a bit stumped. I checked the structure of the tables and things look compatible.
>
>Any ideas??
>
>Below is the SQL commands I'm using to create the two views.
>
>*!* Create Major App report view #2 (get maucode name)
>
>CREATE SQL VIEW rvmajorap2 AS SELECT *, ;
> allcodes.dispval AS usedby;
> FROM rvmajorap1 ;
> LEFT JOIN allcodes ON rvmajorap1.maucode = allcodes.codeno ;
> ORDER BY sysname
>
>*!* Create Major App report view #1 (get matcode name)
>
>CREATE SQL VIEW rvmajorap1 AS SELECT *, ;
> allcodes.dispval AS support;
> FROM majorapp ;
> LEFT JOIN allcodes ON majorapp.matcode = allcodes.codeno ;
> WHERE majorapp.acode = ?caid
>
>Many thanks as always!
>
>Mandy
I cannot say by sure, it seems to me that second view complains about changes in the first view definitions which it's based on. I guess your life would be much easier if you don't use views for reporting purposes: it's obvious redundancy.
Edward Pikman
Independent Consultant