>Hello Mark Thank you Very much its working fine.
>
>Mark Can you please advice me what am i suppose to do i have a small problem.
>I have a form in that form when i click the prev & next buttons the data is not appearing from the table. but the data is saving properly in the table.
>when i checked the code in the prev & next button it is pointing to a local view in the database. "cnchronforsub_view"

First, you should only create this view once. Are you creating it every time you run the form? Second, what Prev/Next button are you using? Your own? If so, do you have a THISFORM.REFRESH() after you skip to the prev or next record? The code you have in your Next/Prev buttons will be more helpful.

>I have a program"createcnchronforsub_view" which is actually creating the above SQLview. in the local view of the database.
>program name is "createcnchronforsub_view"
>when i opened the program the code is as follows:(I am pasting the first few lines of the code.)

>+++++++code starts from here+++++++
>CREATE SQL VIEW "CNCHRONFORSUB_VIEW" ;

>>> snip <<<

>My question is when i create a new exe from the build options. when it creates the exe is that going to consider is there are any modifications to the program(createcnchronforsub_view)and also in the localview of the database or not.

As long as you have created the view, the code you used to do so no longer matters. The code used to create the view in your EXE is now actually stored in the database container [DBC/DCT] files.

Mark McCasland
Midlothian, TX USA