> > t fill this column with date give me error because he fill it with 0 value instead null notes my foreign table column data type int
> >
> > REQUERY('viewalias') is a function that refreshes an open view cursor by loading it again, usually with a changed parameter for the WHERE clause.
> >
> > List- and comboboxes have a .Requery() method to refill the items of the Listbox/combobox after a change to the RowSource.
> >
> > CursorFill is a method of the CursorAdapter class that creates a VFP cursor and moves data from the current ADODB.RecordSet object into the VFP cursor.
> >
> > -Anders
>
> So I have cursor adapter work with MS SQL Database when I need see what data has been changed without change in select statement I can use Requery
>
> Waseem Waheeb


No, you call the CursorAdapter.CursorRefresh(). The main purpose is not to see what has been changed by some other user, but to get a completely new dataset by supplying a new searchcondition for the WHERE clause.
See Example 1 in VFP's Help for the CursorAdapter CursorRefresh() method.

-Anders