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