I don't see any views in the code you posted. What view it's complaining about?
>I have a problem. what i am trying to do is simple enough, I have 2 call systems, both held in seperate folders but build on the same framework, they use tables of the same name, but in different folders, etc. I need to pass details from one to the other, befor ei was creating a dbf with 1 line and saving it into a sub folder. then a timer in the other program would import it, only problem here was that it the users was doing something in the second call system this would cause an error. So what i decided to do was this
>
>mlocation = ALLTRIM(TBD_valx3) + "zfnwc"
>SELECT 0
>USE &mlocation ALIAS 'NWC2'
>SELECT NWC2
>SEEK lclcalnum ORDER CMA_calnum
>IF FOUND()
> * should not happen - do nothing, as call already there
>ELSE
> * add in the details to the limited system
> SELECT NWC
> SCATTER MEMO MEMVAR
>
> SELECT NWC2
> APPEND BLANK
> GATHER MEMVAR MEMO
> ....
> SELECT NWC2
> USE
>
>this works but on the save of the form there is a requery that is necessary and it gives me this error.
>1542/Base table fields have been changed and no longer match view
>Now these tables in both folders are fine but this error always comes up. any ideas?
>~M
--sb--