Hi Barbara
OK, I've tested the buffering now. You were "on the money". VFP was putting the table in row buffered mode, even though my form was set to 0 and the cursor set to 1 (use form setting)
I have to explicitly set all the cursors to 0 in the DE.
Thanks :-)


>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   && A cursor
>>cc= 0
>>scan
>>   cc= m.cc + 1
>>   insert into SeriNo ;   && a "real" table
>>      (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   && the most recently insert line from SeriNo doesn't make it!
>>

>>
>>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