Sorry Barbara, I wasn't able to test SKIP 0, but I now believe you're right about the buffering. I have the form buffering set to 0, "none" and the cursor in the data environment set to 1, "use form setting". There's a bug in VFP whereby the cursor will sometimes ignore the form setting in this case. I've run against that one before but had forgotten. Must be getting too old.
So I'll test that shortly.
Thanks again
>David,
>I'm sorry I wasn't clear - the 'bound control' I mentioned was in my analogy to a textbox not updating a table. I'd still be curious if a SKIP 0 command worked.
>
>I know you said this is a free table, but what about buffering? A row buffered table would save every record when you insert the next record, but the last one wouldn't yet be saved to disk.
>
>Barbara
>
>
>>Hi Barbara,
>>There's no bound control. It's all happening in code.
>>
>>select C_Seri
>>cc= 0
>>scan
>> cc= m.cc + 1
>> insert into SeriNo ;
>> (SeriNo, JNum , ItemID, Part) ;
>> values ;
>> (C_Seri.SeriNo, .jnum, C_Seri.ItemID, C_Seri.Part)
>>endscan
>>select JNum, ItemId, SeriNo, Part ;
>> from SeriNo ;
>> where JNum = .jnum ;
>> into table T_Seri
>>
>>
>>If I move the record pointer prior to the query it works fine!
>>
>>>David,
>>>What happens if you use "Skip 0"? I think this is analogous to making a change in a textbox but not moving off the control - the data never gets to the bound control because VFP is still waiting for you to tell it "I'm done with