>Hello,
>
>I am scanning a set of records which have been loaded by refreshing a cursoradapter, but I also need to refresh every record at the time I skip from record to record in order to detect changes on some fields and make decisions to process it or not.
>
>
>I know that REFRESH() does not work with CAs in VFP 8 and that VFP9 has AutoRefresh method or property to solve it; But, how can I implement it with VFP 8 and CursorAdapters ?
>Any workaround, trick or idea,
>
>Thanks,
>
>Juan C.
If you set Buffering to Record then whenever you move from record to record, the CA will update the backend data. You actually don't need to do anything. The CA has builtin code to find out what has bneen changed/deleted/added and will construct the code automatically and send to the backend.
If buffering is set to file then you have to do a tableupdate() to update the backend.