Try modifying your report. If you have to, remove the view from the report and re-add it. Is the report using a private DS? I have all my reports use a default DS and use a Form to control my reporting functions. This way, I do not have to put any views or tables in the DE of my reports.

>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