Hi Bharat

>The program works fine except when I create exe and run it, it opens the 'Open dialog box' asking for opening the table. I have closed the databse and tried to open the view like
>clear
>Close databases all
>open database &database
>use rv_tbltemp2
>go top
>...
>even then it doesnot open the view..any comments.

Looks as though the path is not set correctly in the EXE. The fact that the USE command is opening the find table dialog would suggest that VFP does not have a search path that includes the data source directory.