Have you tried removing the view from your Report's DE and adding it back.
>Hi. I have a view (which I built into my DBC). I had previously defined this view and now I have redefined it (changed it). Also, I use Stonefield and can go into Stonefield and look at the SQL and it is my new definition. In the command prompt I can use mydatabase!myview and a browse shows me I am getting the new definition. (Good so far!). But when I run my app and call the report that uses that view it gets the old definition. (Why??) I have tried exiting Foxpro and going back in (Just in case), rebuilding my app, suspending and requerying the view, suspending and closing the view and reopening it but NOTHING works. It still seems stuck on the old definition. I even tried DELETE VIEW myView from the command prompt and redefined it again. Still won't cooperate. I even cleaned up my database (within Stonefield). GR GR GR. What am I missing ... or ... how can I make my app see the correct definition?
>
>Thanks for the help,
>
>Sandi Cassidy