Thank you.
>We use this command to change this behavior globally. It is in the our base Application class and in the Environment Manager for each project.
> SET SQLBUFFERING ON && Default is OFF. VFP 9.
>I always want the buffered data.
>
>>>>Hi,
>>>>
>>>>I am having a very strange (at least to me) problem. I have a cursor of CursorAdapter displayed in a grid. The cursor has a column SEL_WO_REC L bound to a check box. I click on the check box on a couple of records. Then in a command button click method I check the value of this column in the cursor (by using BROWSE command). The value is .T. for those records that I checked.
>>>>Then I select records from this cursor as follows:
>>>>
>>>>
>>>>select * from ca_cursor into cursor tempcurs
>>>>
>>>>
>>>>But the value of this column in tempcurs is .F. for all records. And when I try to select records that have the column SEL_WO_REC true, nothing is selected. The code:
>>>>
>>>>select * from ca_cursor where SEL_WO_REC into tempcurs
>>>>
>>>>
>>>>I tried to include NOFILTER into the SQL Select but it didn't make a difference.
>>>>
>>>>What am I missing?
>>>
>>>BUFFERING is what you are missing, probably
>>>
>>>try
>>>
>>>select;
>>> cur1.*;
>>> from ca_cursor AS Cur 1 WITH (BUFFERING=.T.);
>>>into cursor tempcurs;
>>>where Cuzr1.SEL_WO_REC
>>>
>>
>>Thank you. The Buffering=.T. is what I was missing.
"The creative process is nothing but a series of crises." Isaac Bashevis Singer
"My experience is that as soon as people are old enough to know better, they don't know anything at all." Oscar Wilde
"If a nation values anything more than freedom, it will lose its freedom; and the irony of it is that if it is comfort or money that it values more, it will lose that too." W.Somerset Maugham