Check SET ANSI/EXACT and SET DELETED settings.

>Hi Sergey:
>
>Let me put the code that work as expected in the VFP Developement enviroment , I add requery to verify that the data is reissue but did not cause any different when i compile the project into an exe. There a report in this application that work fine that make me think the data is there why this local view does not get populated when I compile.
>
>

>===========================================================================
>mdate1 = STRTRAN(DTOC(ThisForm.Cem_date_ctrl1.Text_Date.value),"/","-")
>mdate2 = STRTRAN(DTOC(ThisForm.Cem_date_ctrl2.Text_Date.value),"/","-")
>
>USE Heat_Support!uansuporttop10 IN 0 ALIAS UANSuportTop25
>SELECT UANSuportTop25
>REQUERY("UANSuportTop25")
>GO top
>REPLACE ALL STARTDATE WITH mDATE1
>REPLACE ALL ENDDATE WITH MDATE2
>GO TOP
>
>COPY TO UANSupportTop10 NEXT 10
>GO top
>I =1
>DO WHILE NOT EOF()
>SCATTER memvar
>USE Heat_support!UANSupportCallType IN 0 ALIAS UANSuportCallType
>SELECT UANSuportCallType
>NewName = "UANSupportCallType"+alltrim(STR(I))
>COPY TO (NEWNAME)
>I = I + 1
>use
>SELECT UANSuportTop10
>SKIP
>IF i = 11
>EXIT
>ENDIF
>
>ENDDO
>
>mdate1 = THISFORM.Cem_date_ctrl1.Text_Date.VALUE
>mdate2 = THISFORM.Cem_date_ctrl2.Text_Date.VALUE
>
>SET DATE TO AMERICAN
>USE heat_support!gregorio ALIAS callog_support_report
>SELECT callog_support_report
>REPORT FORM (mreport_name) PREVIEW
>SET DATE TO YMD
>
>USE
>CLOSE DATABASES ALL
>
>OPEN DATABASE heat_support
>
>============================================================