>Hi Everyone,
>
>I am working with VFP 6 report designer and have created a report based on a combination of 3 different views. If I run the report from within my App for the first time, the data is correct. If I make changes to any of the tables involved with the views, the information is NOT updated. However if I quit the application and close all opened tables (left by the report), the queries reflect the last changes.
>
>I checked to make sure if AutoCloseTables property of the report's data environment was set to .T., and it was. However tables and views are still left opened.
>
>Any ideas of how to solve this situation ?
If the report doesn't close the tables, that means it doesn't open them. I believe you open the tables and views in some other place (maybe the form or the menu where the report is called from). Try requerying the views in that specific place.
Hope this helps.
Grigore Dolghin
Class Software.