I am using remote views in my application. In the past I have found that when I have a remote view that uses 'select *', and then, later on, the table definition changes, if I attempt to open that view from the command line, I get the error 'base table fields have changed' and the view won't open. If the view is referenced in the DE, I get the message 'Please wait', in an endless loop, and the form hangs. If I modify the view to explicitly name the fields everything is ok.

I am now gettig a similar error, but I can't find the offending view, or determine if it is the same problem. In debugging it, I found the following:

1) I put wait windows in the form load, the de before open tables, and the open tables events.

1) I found that: a) first the before open tables event fires, then the form load fires, then the before open tables event fires again, then the load fires again, in an endless loop. I'm pretty sure that the Please wait message is occuring between the firings of the before open tables and the load.

Can anyone explain this behavior, and help me to trace through which view and/or other DE related issue is causing this problem?


TIA