>Hi
>
>In Load of my form , i do :
>
>
>ThisForm.aTables[1] = "Tmp\" + SUBSTR(SYS(2015), 3 , 10 )
>
>SELECT ... INTO TABLE ThisForm.aTables[1]
>
>Select aLIAS()
>USE
>
>Use (ThisForm.aTables[1]) in 0 alias TmpNCOri
>
>
>After , in any property of my form , i do
>
>Select TmpNCOri
>&& Other commands that work with table TmpNCOri
>
>Sometimes work ok , but sometimes , TmpNCOri is out of date , for example i only see one record , but i Know that TmpNCOri should have two records .
>
>If i make this
>
>Select TmpNCOri
>BROWSE
>&& Other commands that work with table TmpNCOri
>
>always and everything works good !
>I don´t want make Browse !
>
>Can you help me ?
>
>Thanks
NOT SURE :
Look at this as if the data has not been actualized (even locally !);
Hence, try to enforce this by means of RLOCK() - UNLOCK, fiddle with SET REFRESH and that kind of stuff.
IMO the working Browse implies the actualization.
Also think of the ever occurring pitfall that at an EOF() situation, a debug-browse will undo this !!
HTH,